Different behaviour for pg_ctl --wait between pg9.5 and pg10

From: Greg k <gregg(dot)kay(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Different behaviour for pg_ctl --wait between pg9.5 and pg10
Date: 2018-03-19 05:55:15
Message-ID: CAC5zpv3KGkC=pqdgiCQ_aJEWGUUKV0GZpvMbMbC6KmY3imGmNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I have a script where after a point-in-time recovery I run

"pg_ctl start -D /data -w -t 86400"

and then try to connect as soon as pg_ctl finishes. With Postgres 9.5.9 (on
Centos 7.4) I can connect at the end. But with Postgres 10.3 I get a
connection error

psql: FATAL: the database system is starting up

It seems with Postgres 10.3 the postmaster.pid file state goes from
'starting' to 'standby' to 'ready' but pg_ctl is saying the server is ready
to accept connections even though the postmaster.pid file says 'standby'.

Thanks,
Greg

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Martin Liška 2018-03-19 08:59:01 Re: BUG #15121: Multiple UBSAN errors
Previous Message Tom Lane 2018-03-19 01:02:59 Re: BUG #15121: Multiple UBSAN errors