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.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Using pg hotbackup directly without wal archives
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgresSQL 9.5 and systemd autorestart but without replication.