Postgres 10 and the pg_ctl "--wait" option

From: Greg k <gregg(dot)kay(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Postgres 10 and the pg_ctl "--wait" option
Date: 2018-03-02 06:04:42
Message-ID: CAC5zpv1Udn5gK5MzrAY=5rCX+46HJKbpUJpZ=MMi-H2G5poMJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Petr Jelinek 2018-03-02 09:44:13 Re: libpq options
Previous Message Michael Paquier 2018-03-02 01:50:38 Re: libpq options