Re: help me understand logs

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: help me understand logs
Дата
Msg-id CAKFQuwadZQqm1kVCFsOg3FKMhz4+6sKrujkHsFgqt2S-YtLX8w@mail.gmail.com
обсуждение исходный текст
Ответ на help me understand logs  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: help me understand logs  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
On Mon, May 9, 2022 at 7:45 PM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
What does this mean?

waiting for server to start....2022-05-10 02:31:15.580 GMT [181072] LOG: starting PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit
2022-05-10 02:31:15.580 GMT [181072] LOG: listening on IPv4 address "0.0.0.0", port 5432
2022-05-10 02:31:15.584 GMT [181072] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-05-10 02:31:15.591 GMT [181072] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
2022-05-10 02:31:19.306 GMT [181073] LOG: database system was interrupted; last known up at 2022-05-09 18:41:34 GMT
...........................................................2022-05-10 02:32:18.265 GMT [181073] LOG: entering standby mode
......2022-05-10 02:32:23.784 GMT [181073] LOG: redo starts at 1985D/BA000028
2022-05-10 02:32:24.293 GMT [181073] WARNING: xlog min recovery request 19872/13105450 is past current point 1985D/BD719420
2022-05-10 02:32:24.293 GMT [181073] CONTEXT: writing block 10 of relation base/16438/120873453_vm
WAL redo at 1985D/BD7183C0 for Btree/VACUUM: ndeleted 92; nupdated 0

... and so on, been going on for a while now

This is an alleged file copy of a pg_basebackup


I think you've managed to restore a functioning warm standby that found some WAL to process and proceeded to do so.

If you want to bring the server backup in non-standby mode you will need to remove the stuff that is making it be a standby.  I don't know that stuff off the top of my head and it also has recently changed.  The v13 documentation will be more useful than I for those specifics.

I don't know what the warnings are - they read like something that should crash the server...

David J.

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: help me understand logs
Следующее
От: Holger Jakobs
Дата:
Сообщение: Re: could not open temporary statistics file