Configuring Replication in Windows 2016 using Postgresql 9.x

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

 



Dear PostgreSQL friends:

I have a terrible task.

Build a replication schema using a Windows Server2016 and PostgreSQL 9.3.

I know, I know , I could have desired, a better or most recent PostgreSQL version, but nope

My current configuration:

Master Server:
postgresql.conf:

wal_level = hot_standby                           

archive_mode = on

archive_command = 'copy "%p" "\\\\127.0.0.1\\archive\\%f"'             

max_wal_senders = 5       

wal_keep_segments = 10  

pg_hba.conf:

host     replication     rep_user       IP-replica  slave/CIDR         trust


Slave Server:


postgresql.conf:

Hot_Standby=On


recovery.conf

restore_command = 'copy "\\\\x.y.z.78\\Archive\\%f" "%p"'

standby_mode = 'on'

primary_conninfo= 'host=x.y.z.78 port=5432 user=rep_user password=rep_user'

trigger_file = 'c:\\temp\\primary_down.txt'


I have made a successfully switch-over, but my new slave server, does not want to be online
I have enabled more detailed debug info, and the only message that appears is:

2020-04-25 11:49:36 COT DEBUG:  attempting to remove WAL segments older than log file 00000000000000000000004A
2020-04-25 11:49:36 COT DEBUG:  SlruScanDirectory invoking callback on pg_multixact/offsets/0000
2020-04-25 11:49:36 COT DEBUG:  SlruScanDirectory invoking callback on pg_multixact/members/0000
2020-04-25 11:49:36 COT DEBUG:  SlruScanDirectory invoking callback on pg_multixact/offsets/0000

My log file keeps growing, but the postgresql service fails to start with a timeout message and never comes online.
what could be happening ?

Please, any idea, can help me
Thanks a lot friends for your postgresql-wise

Best Regards

[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