public inbox for [email protected]  

help / color / mirror / Atom feed

Postgres 10 and the pg_ctl "--wait" option
2+ messages / 1 participants
[nested] [flat]

* Postgres 10 and the pg_ctl "--wait" option
@ 2018-03-02 06:04  Greg k <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Greg k @ 2018-03-02 06:04 UTC (permalink / raw)
  To: [email protected]

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgres 10 and the pg_ctl "--wait" option
@ 2018-03-19 05:51  Greg k <[email protected]>
  parent: Greg k <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Greg k @ 2018-03-19 05:51 UTC (permalink / raw)
  To: [email protected]

This seems to be different behaviour between pg9.5 and pg10. Pg9.5 does not
give a connection error once "pg_ctl --wait ..." finishes. So I've moved
this to the pgsql-bugs list.

Greg

On Fri, 2 Mar 2018 at 17:04 Greg k <[email protected]> wrote:

> 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
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2018-03-19 05:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-03-02 06:04 Postgres 10 and the pg_ctl "--wait" option Greg k <[email protected]>
2018-03-19 05:51 ` Greg k <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox