Re: PostgresSQL 9.5 and systemd autorestart but without replication.

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

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

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