Re: [GENERAL] Streaming Replication Without Downtime

Venkata B N Database consultant -- Forwarded message -- From: *Achilleas Mantzios* <ach...@matrix.gatewaynet.com <mailto:ach...@matrix.gatewaynet.com>> Date: 2017-02-17 11:20 GMT-02:00 Subject: Re: [GENERAL] Streaming Replication Without Downtime To: pgsql-

Re: [GENERAL] Streaming Replication Without Downtime

u using by the way ? > If I do so, do I need do restart the master or just a reload will do it? > No need to restart, "reload" will do. Venkata B N Database consultant > -- Forwarded message -- > From: Achilleas Mantzios <ach...@matrix.gatewaynet

Fwd: [GENERAL] Streaming Replication Without Downtime

s! Gabriel -- Forwarded message -- From: Achilleas Mantzios <ach...@matrix.gatewaynet.com> Date: 2017-02-17 11:20 GMT-02:00 Subject: Re: [GENERAL] Streaming Replication Without Downtime To: pgsql-general@postgresql.org Gabriel you are thinking this in the correct way

Re: [GENERAL] Streaming Replication Without Downtime

Gabriel you are thinking this in the correct way, but its really : pg_basebackup -D --write-recovery-conf --progress --xlog-method=stream -h then you just edit recovery.conf (if needed), tweak postgersql.conf (if needed) and start the standby . On 17/02/2017 15:09, Gunnar "Nick" Bluth

Re: [GENERAL] Streaming Replication Without Downtime

(sorry for the toppost, mobile device) What you're looking for is pg_basebackup with - - xlog=stream, I guess. Regards, Nick Am 17. Februar 2017 14:06:36 MEZ schrieb Gabriel Ortiz Lour : >Hi all, >I've been searching for a way to initialize a new Hot Standby node

[GENERAL] Streaming Replication Without Downtime

Hi all, I've been searching for a way to initialize a new Hot Standby node with Streaming Replication withou the need for stop or even restarting the master. Of course the master is already with the needed SR configs. I know I have to use pg_start_backup/pg_stop_backup, but i'd like some