[GENERAL] Streaming Replication Without Downtime - Mailing list pgsql-general

From Gabriel Ortiz Lour
Subject [GENERAL] Streaming Replication Without Downtime
Date
Msg-id CAJc6w1Npj+C3+Jvu2AHLWKm2MShzy-xSskXt87UYJ3=w0DiGwg@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Streaming Replication Without Downtime  ("Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>)
List pgsql-general
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 tips, or a link to some tutorial, with the order of the steps.

  I assume will be something like:

-  configure Slave for SR
-  pg_start_backup()
-  rsync PGDATA to slave
-  start PG on the slave
-  pg_stop_backup()

  Anything i'm thinking wrong?

Thanks in advance,
Gabriel

pgsql-general by date:

Previous
From: Hannes Erven
Date:
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Next
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: [GENERAL] Streaming Replication Without Downtime