Message-ID: <accd61e0-9a55-73ee-6554-b2741f539111@gmail.com>
Date: Tue, 13 Dec 2022 09:57:04 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.2.2
Subject: Re: WAL replication from an Old Production server
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CAKgGyB9F9DcwuLrkVorXLx8MLU8XxBbT2ziKDr2YssAmeivDOw@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CAKgGyB9F9DcwuLrkVorXLx8MLU8XxBbT2ziKDr2YssAmeivDOw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/accd61e0-9a55-73ee-6554-b2741f539111%40gmail.com>
Precedence: bulk

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.