Re: Streaming Replication Error

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Streaming Replication Error
Дата
Msg-id CAMkU=1wmWpkk1E0HXRzPd7ABqjO1ZBa4_Y=YXwf9t607tx=mhw@mail.gmail.com
обсуждение исходный текст
Ответ на Streaming Replication Error  (<soumik.bhattacharjee@kpn.com>)
Ответы RE: Streaming Replication Error
Список pgsql-admin
Дерево обсуждения
On Fri, Dec 20, 2019 at 11:08 AM <soumik.bhattacharjee@kpn.com> wrote:

Hi Experts,

 

I have set up streaming replication on PostgreSQL 12.1

 

The master and slave are configured as below and WAL files are accumulating on the master.

 

However, something is wrong as I get complaints that the WAL files are missing after a pg_restore on MASTER


You ran pg_restore on the master?  Why did you do that?  Doesn't that mean you now have a new master, different from the old master?  Did you restore into a new instance, or into the existing instance?  What command line did you use?

 

SLAVE

 ...

2019-12-20 16:37:08.042 CET [21981] FATAL:  could not receive data from WAL stream: ERROR:  requested WAL segment 000000010000000100000076 has already been removed

 

 

Then the pg_basebackup is run and the slave started.


Presumably you just didn't restart the slave.  You blew away the old one entirely, and started the new one created by the pg_basebackup.

What was the command line used for pg_basebackup?
 

 

The slave has all the data as of the time of the backup, but no new data from the WAL files, and the error above.


This is confusing.  You got the above errors before you did the new pg_basebackup, or after?
 

 

max_wal_senders = 10         

wal_keep_segments = 120

 

What have I mis-configured?


Your email doesn't seem to be written in chronological order, and you didn't include the parameters for the commands you ran, so it is hard to say what you did wrong, as we don't know what you did.

It could be that your replica is seeking files from the wrong master.
 

Do we need to enabled archive_mode = on for streaming replication?


That can sometimes be useful, but it is not necessary.  You can use a replication slot to force the master to retain sufficient logs, or you can set wal_keep_segments high enough that it (probably) keeps enough on its own.

One reason I sometimes find archive_mode to be useful in a streaming setup is that I can inject a compression step.  WAL files compress very well, and you don't get that compression with a streaming connection.  So if you fall behind and have a slow network, you can catch up much faster using a compressed archive.

Cheers,

Jeff

В списке pgsql-admin по дате отправления: