public inbox for [email protected]  

help / color / mirror / Atom feed

From: Greg k <[email protected]>
To: [email protected]
Subject: Postgres 10 and the pg_ctl "--wait" option
Date: Fri, 02 Mar 2018 06:04:42 +0000
Message-ID: <CAC5zpv1Udn5gK5MzrAY=5rCX+46HJKbpUJpZ=MMi-H2G5poMJQ@mail.gmail.com> (raw)

In PostreSql 10, the documentation for pg_ctl and the "--wait" option says
"Startup is considered complete when the PID file indicates that the server
is ready to accept connections."

When I do a point-in-time recovery followed by a start with
"/usr/pgsql-10/bin/pg_ctl start -D /data -w -t 86400", I then try to
connect immediately after pg_ctl finishes. But I get a connection error
"psql: FATAL:  the database system is starting up" . It seems the
postmaster.pid file state goes from 'starting' to 'standby' to 'ready' but
pg_ctl is saying the server is ready to accept connections when the
postmaster.pid file says 'standby'. Am I misunderstanding the documentation?

Thanks,
Greg

view thread (2+ 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]
  Subject: Re: Postgres 10 and the pg_ctl "--wait" option
  In-Reply-To: <CAC5zpv1Udn5gK5MzrAY=5rCX+46HJKbpUJpZ=MMi-H2G5poMJQ@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