Re: WAL replication from an Old Production server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Hello KK,

I recommend you to check the link below. It includes a step by step tutorial for streaming replication.

On Tue, 13 Dec 2022 at 12:17, KK CHN <> wrote:

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.

Best regards.


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux