Re: [GENERAL] HOT standby on windows not working

2014-04-10 Thread Haribabu Kommi
On Fri, Apr 11, 2014 at 8:15 AM, CS_DBA wrote: > Hi All; > > We're setting up a HOT standby on Windows 2000 server and PostgreSQL 9.2 > > We do this: > I've also tried this approach: > > > 1) Master postgresql.conf file > Modify the following settings: > listen_address = '*' > wal_level = hot_stan

[GENERAL] HOT standby on windows not working

2014-04-10 Thread CS_DBA
Hi All; We're setting up a HOT standby on Windows 2000 server and PostgreSQL 9.2 We do this: 1) stop both servers 2) copy the master data directory to the slave 3) edit the master postgresql.conf file as follows: Modify the following listen_address = ‘*’ wal_level = hot_standby max_wal_sender