pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWAL replication from an Old Production server
3+ messages / 3 participants
[nested] [flat]
* WAL replication from an Old Production server
@ 2022-12-13 10:16 KK CHN <kkchn.in@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: KK CHN @ 2022-12-13 10:16 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
List,
I have to perform WAL Streaming replication configuration for
An existing small production server with 600 GB of size grown over for
two years. There is no WAL replication in place configured as of now.
2. If I want to perform WAL replication to a new Standby Server
How to copy the 600 GB of DB data to Standby? OR when we configure
the WAL replication attributes on primary and standby will the Standby
automatically copy all the 600 GB data to the defined WAL archive dir ?
Or Do I need to manually copy the data directory of primary by SCP over NW
or by copying the data directory of Primary to a USB disk and manually
copy to the WAL archive_dir folder defined in the standby ? What method
to follow ? why?
3. In WAL streaming replication what ports/protocols are used for copying
the data directory of primary to archive_dir of standby server and for
Streaming ?
yours,
Krishane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: WAL replication from an Old Production server
@ 2022-12-13 15:57 Ron <ronljohnsonjr@gmail.com>
parent: KK CHN <kkchn.in@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ron @ 2022-12-13 15:57 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 12/13/22 04:16, KK CHN wrote:
> List,
>
> I have to perform WAL Streaming replication configuration for
>
> An existing small production server with 600 GB of size grown over for
> two years. There is no WAL replication in place configured as of now.
>
> 2. If I want to perform WAL replication to a new Standby Server
> How to copy the 600 GB of DB data to Standby? OR when we configure
> the WAL replication attributes on primary and standby will the Standby
> automatically copy all the 600 GB data to the defined WAL archive dir ?
>
> Or Do I need to manually copy the data directory of primary by SCP over
> NW or by copying the data directory of Primary to a USB disk and
> manually copy to the WAL archive_dir folder defined in the standby ?
> What method to follow ? why?
>
> 3. In WAL streaming replication what ports/protocols are used for copying
> the data directory of primary to archive_dir of standby server and for
> Streaming ?
The Google search "how to set up streaming replication in postgresql 12"
answered all my questions.
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: WAL replication from an Old Production server
@ 2022-12-14 12:48 Samed YILDIRIM <samed@reddoc.net>
parent: KK CHN <kkchn.in@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Samed YILDIRIM @ 2022-12-14 12:48 UTC (permalink / raw)
To: KK CHN <kkchn.in@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hello KK,
I recommend you to check the link below. It includes a step by step
tutorial for streaming replication.
https://wiki.postgresql.org/wiki/Streaming_Replication
On Tue, 13 Dec 2022 at 12:17, KK CHN <kkchn.in@gmail.com> wrote:
> List,
>
> I have to perform WAL Streaming replication configuration for
>
> An existing small production server with 600 GB of size grown over for
> two years. There is no WAL replication in place configured as of now.
>
> 2. If I want to perform WAL replication to a new Standby Server
> How to copy the 600 GB of DB data to Standby? OR when we configure
> the WAL replication attributes on primary and standby will the Standby
> automatically copy all the 600 GB data to the defined WAL archive dir ?
>
> Or Do I need to manually copy the data directory of primary by SCP over
> NW or by copying the data directory of Primary to a USB disk and manually
> copy to the WAL archive_dir folder defined in the standby ? What method
> to follow ? why?
>
It is up to you. You can initialise your standby instance by either using
pg_basebackup or copying the cluster manually.
>
> 3. In WAL streaming replication what ports/protocols are used for copying
> the data directory of primary to archive_dir of standby server and for
> Streaming ?
>
It uses PostgreSQL's replication protocol and PostgreSQL's port.
https://www.postgresql.org/docs/15/protocol-replication.html
Best regards.
Samed YILDIRIM
>
> yours,
> Krishane
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-12-14 12:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-13 10:16 WAL replication from an Old Production server KK CHN <kkchn.in@gmail.com>
2022-12-13 15:57 ` Ron <ronljohnsonjr@gmail.com>
2022-12-14 12:48 ` Samed YILDIRIM <samed@reddoc.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox