[GENERAL] Streaming Replication Without Downtime

Поиск
Список
Период
Сортировка
От Gabriel Ortiz Lour
Тема [GENERAL] Streaming Replication Without Downtime
Дата
Msg-id CAJc6w1Npj+C3+Jvu2AHLWKm2MShzy-xSskXt87UYJ3=w0DiGwg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Streaming Replication Without Downtime  ("Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>)
Список 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 по дате отправления:

Предыдущее
От: Hannes Erven
Дата:
Сообщение: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Следующее
От: "Gunnar \"Nick\" Bluth"
Дата:
Сообщение: Re: [GENERAL] Streaming Replication Without Downtime