Re: [GENERAL] Streaming Replication Without Downtime

2017-02-20 Thread Achilleas Mantzios
ata B N Database consultant -- Forwarded message -- From: *Achilleas Mantzios* mailto: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 <mailto:pgsql-general@

Re: [GENERAL] Streaming Replication Without Downtime

2017-02-20 Thread Venkata B Nagothi
e you 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 > Date: 2017-02-17 11:2

Re: [GENERAL] Streaming Replication Without Downtime

2017-02-17 Thread Achilleas Mantzios
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 wrote:

Re: [GENERAL] Streaming Replication Without Downtime

2017-02-17 Thread Gunnar "Nick" Bluth
(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 with >Streaming Replicati