From: | Forum Writer <forumwriter007(at)gmail(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | WAL-files is not removing authomaticaly |
Date: | 2021-03-10 12:34:27 |
Message-ID: | CAHAzDi=7s2UpiFKQyQb+yNqFLaL3jrH=n2z=f52U8fc=QXbc7Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
Have Streaming replica with 2 hosts, master and slave with PostgreSQL 10.6.
Replica works fine and data from master copying to slave without any
problem,
but on slave have a problem: wal-files in catalog ${PGDATA}/pg_wal is not
removing authomaticaly and may be collects over some years.
Both, master (1.1.1.1) and slave (2.2.2.2), have simmilar replication slots:
master=# select * from pg_replication_slots;
slot_name | plugin | slot_type | datoid | database | temporary |
active | active_pid | xmin | catalog_xmin | restart_lsn |
confirmed_flush_lsn
---------------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
standby_slot | | physical | | | f | t
| 1184 | | | 8/1C16C508 |
(1 row)
slave=# select * from pg_replication_slots;
slot_name | plugin | slot_type | datoid | database | temporary |
active | active_pid | xmin | catalog_xmin | restart_lsn |
confirmed_flush_lsn
---------------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
standby_slot | | physical | | | f | t
| 1184 | | | 8/1C16C508 |
(1 row)
which seted in ${PGDATA}/recovery.done on master:
standby_mode = 'on'
primary_conninfo = 'user=pgadmin host=1.1.1.1 port=5432 user=pgadmin
sslmode=prefer sslcompression=1'
recovery_target_timeline = 'latest'
trigger_file = 'failover'
restore_command = 'cp /opt/archivelog/%f %p'
archive_cleanup_command = '/usr/pgsql-10/bin/pg_archivecleanup
/opt/archivelog %r'
primary_slot_name = 'standby_slot'
and seted in ${PGDATA}/recovery.conf on slave:
standby_mode = 'on'
primary_conninfo = 'user=pgadmin host=2.2.2.2 port=5432 user=pgadmin
sslmode=prefer sslcompression=1'
recovery_target_timeline = 'latest'
trigger_file = 'failover'
restore_command = 'cp /opt/archivelog/%f %p'
archive_cleanup_command = '/usr/pgsql-10/bin/pg_archivecleanup
/opt/archivelog %r'
primary_slot_name = 'standby_slot'
Both archive_cleanup_command's on both hosts works fine in console and no
needs to set permissions on /opt/archivelog or
/usr/pgsql-10/bin/pg_archivecleanup.
In ${PGDATA}/postgresql.conf on both hosts sets:
max_wal_size = 8GB
wal_keep_segments = 32
But yesterday pg_wal was 16G and had 1018 files inside, thats why there was
no other way except deleting its manualy, but not of all,
just 6 hundreds files, which had modification time before September 2020
except 000000010000000000000034.00000028.backup.
Trying to rebuild slave from master with: making pg_start_backup, copying
${PGDATA} files from master to slave (without removing on slave any files
in ${PGDATA}),
pg_stop_backup, tunning settings on slave and run it again had no any
success, wal-files still is not removing automaticaly.
Does anybody knows how to fix it ?
Regards, Andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2021-03-10 12:58:20 | Re: unexpected character used as group separator by to_char |
Previous Message | Vincent Veyron | 2021-03-10 12:19:28 | Re: unexpected character used as group separator by to_char |