Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated - Mailing list pgsql-general

From Paul Förster
Subject Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated
Date
Msg-id B7E0C7C6-865B-4632-B10A-11B2E468D40A@gmail.com
Whole thread Raw
In response to How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Hi Andrus,

> On 31. May, 2020, at 21:47, Andrus <kobruleht2@hot.ee> wrote:
> replikaator@[unknown] ERROR:  requested WAL segment 00000001000002CF000000E9 has already been removed

the message says it all. You need to copy the WAL file 00000001000002CF000000E9 and newer to the replica's pg_wal
directorybecause it has been removed already on the master site. Obviously, you can only do that if the files have been
archived.Otherwise, you'd have to fully reinitiate the replica. 

Replication will start again as soon as the requested WALs are copied over to the replica.

Use a replication slot to avoid this situation. If you use a replication slot, the master will only remove WAL files
whichare not needed by any one replica. 

Hope this helps.

Cheers,
Paul


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to start slave after pg_basebackup. Why min_wal_size andwal_keep_segments are duplicated
Next
From: tony@exquisiteimages.com
Date:
Subject: Re: pg_dump of database with numerous objects