Thread: Streaming replication issue post upgrade from version 11 to 14 on windows 2016 Server
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
Hi Vamsi,
--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
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@gmail.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 luckThankyouvamshi.chava
Muhammad Ikram