Re: PostgresSQL 9.5 and systemd autorestart but without replication.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Poul Kristensen <bcc5226(at)gmail(dot)com>
Cc: Scott Mead <scottm(at)openscg(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Date: 2016-10-26 13:10:49
Message-ID: 16413.1477487449@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Poul Kristensen <bcc5226(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Frost 2016-10-26 13:30:56 Re: Using pg hotbackup directly without wal archives
Previous Message Poul Kristensen 2016-10-26 09:57:46 Re: PostgresSQL 9.5 and systemd autorestart but without replication.