Re: PostgresSQL 9.5 and systemd autorestart but without replication.

From: "Hunley, Douglas" <douglas(dot)hunley(at)openscg(dot)com>
To: Poul Kristensen <bcc5226(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Date: 2016-10-13 14:30:08
Message-ID: CAAD=pwEvuFc513-yrqxb6d9m4rw1Yzh4Xg4AW317aTWOynzBiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Oct 13, 2016 at 6:00 AM, Poul Kristensen <bcc5226(at)gmail(dot)com> wrote:

> This morning I noticed that my 2 PG virtual servers had made an automatic
> restart at exactly the same time 00:00. The 2 servers is running and
> accepting connections but no WALL sender and no WALL receicver is running.
> Why don't replication follow up!
> Do I have to make a new pg_basebackup from primarily to replica?
> OS: RHEL 7.2
>

Is the recovery.conf file still present and valid in $PGDATA on the slave?
Any errors in the slave's pg_log directory concerning the replication?

--
{
"name" : "douglas j hunley",
"email" : "douglas(dot)hunley(at)openscg(dot)com <doug(dot)hunley(at)gmail(dot)com>",
"title" : "database engineer",
"phone" : "+1 732 339 3419 x163"
}

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matteo Fabbri 2016-10-13 15:18:21 Re: pg_restore --clean --create reference documentation incongruity
Previous Message Hunley, Douglas 2016-10-13 14:23:19 Re: pg_restore --clean --create reference documentation incongruity