Streaming Replication Postgresql 16

Поиск
Список
Период
Сортировка
От Prasanth
Тема Streaming Replication Postgresql 16
Дата
Msg-id 9073db09-3a51-89be-ff76-f6252b799411@pangburngroup.com
обсуждение исходный текст
Ответы Re: Streaming Replication Postgresql 16  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Hi,

Do the below processes look OK for a standby (streaming replication) server? We recently migrated from 12 to 16. I don't remember seeing "startup recovering"  process for a long time after starting of standby server on postgresql 12, it has been long time so I could be wrong.  Just want to make sure my standby is in a good shape. I have run some queries on standby to see if latest data is available and seems like it is there.

postgres   16909       1  0 May15 ?        00:00:00 /usr/lib/postgresql/16/bin/postgres -D /var/lib/postgresql/16/main -c config_file=/etc/postgresql/16/main/postgresql.conf
postgres   16910   16909  0 May15 ?        00:00:00 postgres: 16/main: logger
postgres   16911   16909  0 May15 ?        00:00:54 postgres: 16/main: checkpointer
postgres   16912   16909  0 May15 ?        00:00:03 postgres: 16/main: background writer
postgres   16913   16909  0 May15 ?        00:03:14 postgres: 16/main: startup recovering 0000000100000085000000E2
postgres   17012   16909  0 May15 ?        00:03:04 postgres: 16/main: walreceiver streaming 85/E24B6000

Also seeing log entries about every 5 minutes as shown below. These were not present when we were running 12.

2024-05-16 16:17:02.981 CDT: : 16911: LOG:  restartpoint starting: time
2024-05-16 16:18:58.337 CDT: : 16911: LOG:  restartpoint complete: wrote 1132 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=113.465 s, sync=1.688 s, total=115.356 s; sync files=155, longest=0.058 s, average=0.011 s; distance=21216 kB, estimate=174182 kB; lsn=85/FCFA8AA8, redo lsn=85/FCB6C578
2024-05-16 16:18:58.337 CDT: : 16911: LOG:  recovery restart point at 85/FCB6C578
2024-05-16 16:18:58.337 CDT: : 16911: DETAIL:  Last completed transaction was at log time 2024-05-16 16:18:57.612916-05.

Appreciate your help.

Thanks,
Prasanth

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Queries in replica are failing
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Streaming Replication Postgresql 16