|
On 22/1/19 8:59 μ.μ., Jeremy Finzel wrote:
Hi,
On 2019-01-22 11:10:27 -0600, Jeremy Finzel wrote:
> P.S. do heed the advice of the others and get more
familiar with the docs
> around WAL archiving.
Logical replication doesn't normally interact with WAL
archiving in any
way, so that seems orthogonal.
But he is manually removing WAL files via cron which
should normally be held until the replication slot doesn't
need it anymore. I do believe that is why he is getting
errors. The suggestion is to rely on Postgres' WAL
archiving rather than removing WAL files manually...
wal retention in pg_wal and wal archiving are different things.
The OP got problems cause he deliberately went on to delete files
in pg_wal which means he used the wrong method to address a wrong
situation.
However, if the OP has still those WAL files archived he can use
them to bring logical replication back in synch. Don't ask me how
I know :
https://www.postgresql.org/message-id/ae8812c3-d138-73b7-537a-a273e15ef6e1%40matrix.gatewaynet.com
|
