Re: PostgresSQL 9.5 and systemd autorestart but without replication. - Mailing list pgsql-admin

From Tom Lane
Subject Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Date
Msg-id 16413.1477487449@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgresSQL 9.5 and systemd autorestart but without replication.  (Poul Kristensen <bcc5226@gmail.com>)
Responses Re: PostgresSQL 9.5 and systemd autorestart but without replication.  (Poul Kristensen <bcc5226@gmail.com>)
List 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 by date:

Previous
From: Poul Kristensen
Date:
Subject: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Next
From: Ayush Goyal
Date:
Subject: Using pg hotbackup directly without wal archives