[Pgpool-general] Is pgpool_walrecrunning needed in Master/Slavemode?

[Daniel.Crespo at l-3com.com]

> From: pgpool-general-bounces at pgfoundry.org
[mailto:pgpool-general-bounces at pgfoundry.org] On Behalf Of Sandeep
Thakkar
> Sent: Thursday, September 22, 2011 12:25 PM
> To: Sandeep Thakkar; Tatsuo Ishii
> Cc: pgpool-general at pgfoundry.org
> Subject: Re: [Pgpool-general] Is pgpool_walrecrunning needed in
Master/Slavemode?
> 
> Also,
> - who will add "hot_standby = on" in the new Standby and remove it
from new Master?
> - who will add "host    replication..." entry in the new Standby's
pg_hba.conf?
> 
> I didn't find all these settings in basebackup. Though, we handle some
of them. Please help.
 
You can have the same pg_hba.conf and postgresql.conf in both database
servers. In postgresql.conf, make sure you have:

wal_level = hot_standby
hot_standby = on

Again, this is specific to PostgreSQL 9.x. Please, look at their
documentation.

Thanks,
-Daniel