Re: PostgresSQL 9.5 and systemd autorestart but without replication.

[Poul Kristensen <bcc5226@xxxxxxxxx>]

Hi !

Hopefully this is a situation in virtuel environments and not on physical

servers with storage on SAN.as replication have to follow up in a autorestart without a manual new basebackup.

Does anyone have experience with replication on physical servers(slaves)?

Thanks

 

Poul

2016-10-13 17:45 GMT+02:00 Poul Kristensen <bcc5226@xxxxxxxxx>:

Thank you for fast respons.

No. The recovery.conf has now replace a recovery.done file on the slave. 

No errors in the pg_log. I have not earlier experienced this situation. 

The feature of autorestart is really nice. 

BTW: I do not quite understand why the recovery.conf are replaced with a recovery.done file.

Thanks

/Poul

2016-10-13 16:30 GMT+02:00 Hunley, Douglas <douglas.hunley@xxxxxxxxxxx>:

On Thu, Oct 13, 2016 at 6:00 AM, Poul Kristensen <bcc5226@xxxxxxxxx> 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@xxxxxxxxxxx",
  "title" : "database engineer",

  "phone" : "+1 732 339 3419 x163"

}

--

Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

--

Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA