> Never, ever, remove WAL files manually.
> A crash might render your database unrecoverable.
You're right, it's not a good idea.
> You'll have to figure out what is blocking WAL removal.
This is my favorite dream!
> Are there archive failures reported in "pg_stat_archiver" and the log?
master=#
.000 EET [97583] [] [] [] []DEBUG: writing stats file
"pg_stat_tmp/db_13212.stat"
2021-03-16 06:32:21.000 EET [97583] [] [] [] []DEBUG: writing stats file
"pg_stat_tmp/db_0.stat"
2021-03-16 06:32:21.013 EET [97575] [] [] [] []DEBUG: server process (PID
35775) exited with exi
parameter
"log_checkpoints" removed from configuration file, reset to default
2021-03-16 09:44:19.937 EET [97585] [] [] [] []DEBUG: parameter
"log_checkpoints" removed from configuration file, reset to default
вт, 16 мар. 2021 г. в 09:40, Laurenz Albe :
> On Tue, 2021-
--
0002014500F6
(1 row)
вт, 16 мар. 2021 г. в 14:21, Laurenz Albe :
> On Tue, 2021-03-16 at 09:49 +0200, Andrew Anderson wrote:
> > 2021-03-16 09:44:03.997 EET [97581] [] [] [] []DEBUG: attempting to
> remove WAL segments older than log file 013E0097
>
> That was the ent
ary_slot_name = 'stanby_slot'
postgres=# show wal_keep_segments;
wal_keep_segments
---
32
(1 row)
but on slave:
$ ls pg_wal/ | wc -l
1892
вт, 16 мар. 2021 г. в 15:53, Laurenz Albe :
> On Tue, 2021-03-16 at 15:31 +0200, Andrew Anderson wrote:
> > вт, 16 ма
You're right, restart_lsn on slave does not changes.
> What's using it?
As I think, streaming replication is using this slot. Does anybody know how
to fix it ?
вт, 16 мар. 2021 г. в 17:44, Tom Lane :
> Andrew Anderson writes:
> >> - replication slot (you said
And will it fix the
automated removing of WAL-files ?
вт, 16 мар. 2021 г. в 19:39, Tom Lane :
> Andrew Anderson writes:
> >> What's using it?
>
> > As I think, streaming replication is using this slot. Does anybody know
> how
> > to fix it ?
>
> Unless you
But maybe there is a way to fix this ? Rebuilding slave from master with
erasing ${PGDATA} on slave does not help.
вт, 16 мар. 2021 г. в 16:56, Laurenz Albe :
> On Tue, 2021-03-16 at 16:11 +0200, Andrew Anderson wrote:
> > postgres=# show wal_keep_segments;
> > wa
Deleting replication slot on slave resolve the issue, now WAL-files
removing automaticaly ! Thanks a lot for your answers !
ср, 17 мар. 2021 г. в 10:59, Andrew Anderson :
> But maybe there is a way to fix this ? Rebuilding slave from master with
> erasing ${PGDATA} on slave does not help.
