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

Re: [GENERAL] Hot standby on Windows

2011-07-14 Thread Craig Ringer
On 14/07/2011 10:05 PM, stefanu wrote: I thought that the command line would be built properly (I mean the %r would be replaced by the caller), but for some reason it is not happening. I don't use hot standby on Windows, but since there's been no other response to this I'll try to have a loo

[GENERAL] Hot standby on Windows

2011-07-14 Thread stefanu
Hello all, I am having a little trouble with a hot standby configuration on Windows, and I was hoping I could find an answer here. Everything works fine (both machines run just fine, and the hot standby works like a charm), except for one problem. The pg_archivecleanup refuses to run; it seems li

[GENERAL] Hot standby on Windows

2011-07-09 Thread stefanu
Hello all, I am having a little trouble with a hot standby configuration on Windows, and I was hoping I could find an answer here. Everything works fine (both machines run just fine, and the hot standby works like a charm), except for one problem. The pg_archivecleanup refuses to run; it seems li