public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muhammad Ikram <[email protected]>
To: Vamsi Chava <[email protected]>
Cc: [email protected]
Subject: Re: Streaming replication issue post upgrade from version 11 to 14 on windows 2016 Server
Date: Wed, 7 Aug 2024 09:32:19 +0500
Message-ID: <CAGeimVouFfdq2_khFdbgF12eB5vE27KYybFffWjfTB1o7Neirw@mail.gmail.com> (raw)
In-Reply-To: <CADcUS2tqR3=eQwqpQY_N2WAX1EJ079FG=FSvX6UzRbgUo-cUEg@mail.gmail.com>
References: <CADcUS2tqR3=eQwqpQY_N2WAX1EJ079FG=FSvX6UzRbgUo-cUEg@mail.gmail.com>

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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Streaming replication issue post upgrade from version 11 to 14 on windows 2016 Server
  In-Reply-To: <CAGeimVouFfdq2_khFdbgF12eB5vE27KYybFffWjfTB1o7Neirw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox