From: | Muhammad Ikram <mmikram(at)gmail(dot)com> |
---|---|
To: | Vamsi Chava <chavavamsichava(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Streaming replication issue post upgrade from version 11 to 14 on windows 2016 Server |
Date: | 2024-08-07 04:32:19 |
Message-ID: | CAGeimVouFfdq2_khFdbgF12eB5vE27KYybFffWjfTB1o7Neirw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Vamsi,
We have been doing these steps to setup streaming replication
--Primay-Server
CREATE ROLE repl REPLICATION LOGIN PASSWORD 'your_password';
postgresql.conf
listen_addresses = '*'
wal_level = replica
archive_mode = on
archive_command = 'copy %p \\path_to_archive\\%f'
max_wal_senders = 3
wal_keep_size = 1024
--pg_hba.conf
host replication repl standby_server_ip/32 auth_method
Creating standby
PGPASSWORD=repl pg_basebackup -F p -C -S pslot1 -h localhost -p 5333 -D
path_to_standby_data_directory -U repl -P -v -R -X stream
--standby-postgresql.conf
primary_conninfo = 'host=primary_server_ip port=5432 user=repl
password=your_password'
restore_command = 'copy \\path_to_archive\\%f %p' # if you are using
archive logs
Hope I did not forget any step.
Regards,
Muhammad Ikram
On Wed, Aug 7, 2024 at 6:11 AM Vamsi Chava <chavavamsichava(at)gmail(dot)com>
wrote:
> Hi Team,
>
> we have upgraded postgresql version 11 to 14 on windows server 2016, post
> upgrade we configured streaming replication. the data is not getting
> replicated. but compared to version 11, 14 is very different in
> configuring replication. Tried from documentation from postgres site. no
> luck, Any help appreciated. Tried many other sites for Windows side
> replication configuration notes. No luck
>
>
> Thankyou
> vamshi.chava
>
--
Muhammad Ikram
From | Date | Subject | |
---|---|---|---|
Next Message | Christophe Pettus | 2024-08-07 04:43:35 | Re: ANALYZE on partitioned tables vs on individual partitions |
Previous Message | Michael Harris | 2024-08-07 04:13:10 | ANALYZE on partitioned tables vs on individual partitions |