Postgres 10 and the pg_ctl "--wait" option

Поиск
Список
Период
Сортировка
От Greg k
Тема Postgres 10 and the pg_ctl "--wait" option
Дата
Msg-id CAC5zpv1Udn5gK5MzrAY=5rCX+46HJKbpUJpZ=MMi-H2G5poMJQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres 10 and the pg_ctl "--wait" option  (Greg k <gregg.kay@gmail.com>)
Список 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

В списке pgsql-docs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: libpq options
Следующее
От: Petr Jelinek
Дата:
Сообщение: Re: libpq options