public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Scott Ribe <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: help me understand logs
Date: Mon, 9 May 2022 19:53:28 -0700
Message-ID: <CAKFQuwadZQqm1kVCFsOg3FKMhz4+6sKrujkHsFgqt2S-YtLX8w@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Mon, May 9, 2022 at 7:45 PM Scott Ribe <[email protected]>
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.
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: help me understand logs
In-Reply-To: <CAKFQuwadZQqm1kVCFsOg3FKMhz4+6sKrujkHsFgqt2S-YtLX8w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox