public inbox for [email protected]
help / color / mirror / Atom feedStreaming replication issue post upgrade from version 11 to 14 on windows 2016 Server
2+ messages / 2 participants
[nested] [flat]
* Streaming replication issue post upgrade from version 11 to 14 on windows 2016 Server
@ 2024-08-07 01:10 Vamsi Chava <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Vamsi Chava @ 2024-08-07 01:10 UTC (permalink / raw)
To: [email protected]
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Streaming replication issue post upgrade from version 11 to 14 on windows 2016 Server
@ 2024-08-07 04:32 Muhammad Ikram <[email protected]>
parent: Vamsi Chava <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Muhammad Ikram @ 2024-08-07 04:32 UTC (permalink / raw)
To: Vamsi Chava <[email protected]>; +Cc: [email protected]
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 <[email protected]>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-08-07 04:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-07 01:10 Streaming replication issue post upgrade from version 11 to 14 on windows 2016 Server Vamsi Chava <[email protected]>
2024-08-07 04:32 ` Muhammad Ikram <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox