Re: PostgresSQL 9.5 and systemd autorestart but without replication.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux