MIME-Version: 1.0
References: 
 <CAC5zpv1Udn5gK5MzrAY=5rCX+46HJKbpUJpZ=MMi-H2G5poMJQ@mail.gmail.com>
In-Reply-To: 
 <CAC5zpv1Udn5gK5MzrAY=5rCX+46HJKbpUJpZ=MMi-H2G5poMJQ@mail.gmail.com>
From: Greg k <gregg.kay@gmail.com>
Date: Mon, 19 Mar 2018 05:51:32 +0000
Message-ID: 
 <CAC5zpv1wqpmhnLQjZwqP5osA+BLffXzRS4FybMgGzN57rCLKfA@mail.gmail.com>
Subject: Re: Postgres 10 and the pg_ctl "--wait" option
To: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000006b17a30567bd8daa"
Precedence: bulk

--0000000000006b17a30567bd8daa
Content-Type: text/plain; charset="UTF-8"

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 <gregg.kay@gmail.com> 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
>

--0000000000006b17a30567bd8daa
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">This seems to be different behaviour between pg9.5 and pg1=
0. Pg9.5 does not give a connection error once &quot;pg_ctl --wait ...&quot=
; finishes. So I&#39;ve moved this to the pgsql-bugs list.<div><br></div><d=
iv>Greg</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr">On Fri, =
2 Mar 2018 at 17:04 Greg k &lt;<a href=3D"mailto:gregg.kay@gmail.com">gregg=
.kay@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div =
dir=3D"ltr"><div>In PostreSql 10, the documentation for pg_ctl and the &quo=
t;--wait&quot; option says &quot;Startup is considered complete when the PI=
D file indicates that the server is ready to accept connections.&quot;</div=
><div><br></div><div>When I do a point-in-time recovery followed by a start=
 with &quot;/usr/pgsql-10/bin/pg_ctl start -D /data -w -t 86400&quot;, I th=
en try to connect immediately after pg_ctl finishes. But I get a connection=
 error &quot;psql: FATAL:=C2=A0 the database system is starting up&quot; . =
It seems the postmaster.pid file state goes from &#39;starting&#39; to &#39=
;standby&#39; to &#39;ready&#39; but pg_ctl is saying the server is ready t=
o accept connections when the postmaster.pid file says &#39;standby&#39;. A=
m I misunderstanding the documentation?</div><div><br></div><div>Thanks,</d=
iv><div>Greg</div></div></blockquote></div>

--0000000000006b17a30567bd8daa--