Configuring Replication in Windows 2016 using Postgresql 9.x

From: Luis Marin <luismarinaray(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Configuring Replication in Windows 2016 using Postgresql 9.x
Date: 2020-04-25 17:10:37
Message-ID: CAEp6HQU0u1HCuuYsZPjKJyyC5Ai9q8pe4C+VemWA2w2kcq+uzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2020-04-25 21:24:26 Re: Startup process in slave
Previous Message Don Seiler 2020-04-25 13:28:55 Re: Wal keep segment