On 20/08/2018 11:58, pavan95 wrote:
Hi Achilleas, Will monitor and get back to you on this. I have concern about one more error for which I have raised a question on this on the following link: http://www.postgresql-archive.org/Space-Related-Errors-in-Postgres-10-4-Logical-Replication-td6034649.html <http://www.postgresql-archive.org/Space-Related-Errors-in-Postgres-10-4-Logical-Replication-td6034649.html> Do you have any idea on the below error: 2018-08-20 10:34:55.801 IST [24955] user@db ERROR: could not create directory "pg_replslot/mysub_14211111_sync_111111.tmp": No space left on device 2018-08-20 10:34:56.036 IST [34222] user@db ERROR: could not create file "pg_replslot/mysub/state.tmp": No space left on device 2018-08-20 10:34:56.053 IST [23444] user@db WARNING: could not create relation-cache initialization file "global/pg_internal.init.11331": No space left on device 2018-08-20 10:34:56.053 IST [23444] user@db DETAIL: Continuing anyway, but there's something wrong.
Man, your system's state is one step from disaster. Increase the space ASAP.
Looking forward to hear from you regarding the lifecycle of snapshots in the publisher side.. Thanks in advance!! Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
