Re: PostgresSQL 9.5 and systemd autorestart but without replication.
От | Poul Kristensen |
---|---|
Тема | Re: PostgresSQL 9.5 and systemd autorestart but without replication. |
Дата | |
Msg-id | CAAOuvVoMpaXNm32n=3QHG2vdmMfCMpeWFx=YzCJF8bAu_h1VLw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: PostgresSQL 9.5 and systemd autorestart but without replication. (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: PostgresSQL 9.5 and systemd autorestart but without replication.
|
Список | pgsql-admin |
It IS the standby server:
--
Result of pg_isready:
/usr/pgsql-9.6/bin/pg_isready -h /tmp -p 5432
/tmp:5432 - rejecting connections
In the pg_log:
2016-10-26 13:30:16.298 UTC > FATAL: the database system is starting up
Thanks
Poul
2016-10-26 15:10 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:
Poul Kristensen <bcc5226@gmail.com> writes:
> Replica(hot_standby) server:
> Is it normal behavior that PostgreSQL 9.6 does a very very slow
> recovery restart point at 1/77472E5 in the pg_log
> while doing this
> postgres: startup process recovering 000000010000000100000077(this
> process has run several days)
If that's the standby server, that process will persist as long as it's in
standby; it's what's responsible for applying WAL received by the
walreceiver process. You should have been able to connect long before
now, though.
regards, tom lane
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
В списке pgsql-admin по дате отправления: