MIME-Version: 1.0
References: <CADcUS2tqR3=eQwqpQY_N2WAX1EJ079FG=FSvX6UzRbgUo-cUEg@mail.gmail.com>
In-Reply-To: <CADcUS2tqR3=eQwqpQY_N2WAX1EJ079FG=FSvX6UzRbgUo-cUEg@mail.gmail.com>
From: Muhammad Ikram <mmikram@gmail.com>
Date: Wed, 7 Aug 2024 09:32:19 +0500
Message-ID: <CAGeimVouFfdq2_khFdbgF12eB5vE27KYybFffWjfTB1o7Neirw@mail.gmail.com>
Subject: Re: Streaming replication issue post upgrade from version 11 to 14 on
 windows 2016 Server
To: Vamsi Chava <chavavamsichava@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000051c671061f1066e8"
Archived-At: <https://www.postgresql.org/message-id/CAGeimVouFfdq2_khFdbgF12eB5vE27KYybFffWjfTB1o7Neirw%40mail.gmail.com>
Precedence: bulk

--00000000000051c671061f1066e8
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 =3D '*'
wal_level =3D replica
archive_mode =3D on
archive_command =3D 'copy %p \\path_to_archive\\%f'
max_wal_senders =3D 3
wal_keep_size =3D 1024

--pg_hba.conf

host replication repl standby_server_ip/32 auth_method


Creating standby

PGPASSWORD=3Drepl 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 =3D 'host=3Dprimary_server_ip port=3D5432 user=3Drepl
password=3Dyour_password'
restore_command =3D '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=E2=80=AFAM Vamsi Chava <chavavamsichava@gmail.c=
om>
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
>


--=20
Muhammad Ikram

--00000000000051c671061f1066e8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Vamsi,<div><br></div><div>We have been doing these step=
s to setup streaming replication=C2=A0</div><div><br></div><div><br>--Prima=
y-Server<br><br>CREATE ROLE repl REPLICATION LOGIN PASSWORD &#39;your_passw=
ord&#39;;<br><br>postgresql.conf</div><div><br>listen_addresses =3D &#39;*&=
#39;<br>wal_level =3D replica<br>archive_mode =3D on<br>archive_command =3D=
 &#39;copy %p \\path_to_archive\\%f&#39;<br>max_wal_senders =3D 3<br>wal_ke=
ep_size =3D 1024<br><br>--pg_hba.conf</div><div><br>host replication repl s=
tandby_server_ip/32 auth_method<br><br><br>Creating standby<br><br>PGPASSWO=
RD=3Drepl pg_basebackup -F p -C -S pslot1 -h localhost -p 5333 -D path_to_s=
tandby_data_directory =C2=A0 -U repl -P -v -R -X stream<br><br><br>--standb=
y-postgresql.conf<br><br>primary_conninfo =3D &#39;host=3Dprimary_server_ip=
 port=3D5432 user=3Drepl password=3Dyour_password&#39;<br>restore_command =
=3D &#39;copy \\path_to_archive\\%f %p&#39; =C2=A0# if you are using archiv=
e logs<br><br></div><div><br></div><div>Hope I did not forget any step.</di=
v><div><br></div><div>Regards,</div><div>Muhammad Ikram</div><div><br></div=
></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr"=
>On Wed, Aug 7, 2024 at 6:11=E2=80=AFAM Vamsi Chava &lt;<a href=3D"mailto:c=
havavamsichava@gmail.com">chavavamsichava@gmail.com</a>&gt; wrote:<br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div di=
r=3D"ltr">Hi Team,<div><br></div><div>we have upgraded postgresql version 1=
1 to 14 on windows server 2016, post upgrade we configured streaming replic=
ation. the data is not getting replicated. but compared to version 11, 14 i=
s very different in configuring=C2=A0replication. Tried from documentation =
from postgres site. no luck, Any help appreciated. Tried many other sites f=
or Windows side replication configuration=C2=A0notes. No luck</div><div><br=
></div><div><br></div><div>Thankyou</div><div>vamshi.chava</div></div><div =
style=3D"outline:none;padding:10px 0px;width:22px;margin:2px 0px 0px"><div =
id=3D"m_-8625374320321613356gmail-:1i0" role=3D"button" aria-label=3D"Show =
trimmed content" aria-expanded=3D"false" style=3D"background-color:rgb(232,=
234,237);border:none;clear:both;line-height:6px;outline:none;width:24px;bor=
der-radius:5.5px"><img style=3D"background: url(&quot;&quot;) 50% 50% / 20p=
x no-repeat; height: 11px; opacity: 0.71; width: 24px;"></div></div></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div>Muhammad Ikram<br><br></div></div></div>

--00000000000051c671061f1066e8--