Re: PostgresSQL 9.5 and systemd autorestart but without replication.

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(dot)hunley(at)openscg(dot)com>:

>
> 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"
> }
>

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