Postgres Pro
Downloads
Home   >   mailing lists

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

From Hunley, Douglas
Subject Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Date
Msg-id CAAD=pwEvuFc513-yrqxb6d9m4rw1Yzh4Xg4AW317aTWOynzBiA@mail.gmail.com
Whole thread Raw
In response to 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
Tree view

On Thu, Oct 13, 2016 at 6:00 AM, Poul Kristensen <bcc5226@gmail.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.hunley@openscg.com",
  "title" : "database engineer",
  "phone" : "+1 732 339 3419 x163"
}

pgsql-admin by date:

Previous
From: "Hunley, Douglas"
Date:
Subject: Re: pg_restore --clean --create reference documentation incongruity
Next
From: Matteo Fabbri
Date:
Subject: Re: pg_restore --clean --create reference documentation incongruity