Replication - standby question

Поиск
Список
Период
Сортировка
От Al-Karim Bhamani (LCL)
Тема Replication - standby question
Дата
Msg-id 6A10EC9E868D14458A7B8DB1232CCEF0F130F0@lclmxhq06.ngco.com
обсуждение исходный текст
Список pgsql-admin

Hi

 

I need some help implementing Hot standby.

 

Here is what I have done.

 

Create a base backup

  1. select pg_start_backup(‘label’);
  2. create a tar of data dir.
  3. restore on standby node
  4. select pg_stop_backup;
  5. ftp WAL files to standby database;
  6. configure recovery.conf file
  7. start postmaster

 

Once I start postmaster it performs recovery and exits and the recovery.conf file is renamed to recovery.done.

 

How can I let postmaster be in recovery mode indefinitely as I will keep on ftp wal from primary

So that my standby remains in sync?

 

In other words make the standby in standby mode and not open.

 

Also once the standby is opened can it be placed in recovery mode again without taking a fresh backup?

 

Please Advice

Thanks.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Sergiusz Jarczyk
Дата:
Сообщение: Re: plperl again but different problem
Следующее
От: Thomas O'Connell
Дата:
Сообщение: Re: plperl