Replication - standby question - Mailing list pgsql-admin

From Al-Karim Bhamani (LCL)
Subject Replication - standby question
Date
Msg-id 6A10EC9E868D14458A7B8DB1232CCEF0F130F0@lclmxhq06.ngco.com
Whole thread Raw
List 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 by date:

Previous
From: Sergiusz Jarczyk
Date:
Subject: Re: plperl again but different problem
Next
From: Thomas O'Connell
Date:
Subject: Re: plperl