> From: [email protected] [mailto:[email protected]] On Behalf Of Sandeep Thakkar > Sent: Thursday, September 22, 2011 12:25 PM > To: Sandeep Thakkar; Tatsuo Ishii > Cc: [email protected] > 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
