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