Re: PostgresSQL 9.5 and systemd autorestart but without replication.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Дата
Msg-id 16413.1477487449@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgresSQL 9.5 and systemd autorestart but without replication.  (Poul Kristensen <bcc5226@gmail.com>)
Ответы Re: PostgresSQL 9.5 and systemd autorestart but without replication.  (Poul Kristensen <bcc5226@gmail.com>)
Список pgsql-admin
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


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

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