On Fri, Apr 11, 2014 at 8:15 AM, CS_DBA <cs_dba@xxxxxxxxxxxxxxxxxxx> 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_standby > max_wal_senders = 3 > > > 2) Modify Master pg_hba.conf file: > hostssl replication al 192.168.91.136/32 trust > > 3) RESTART MASTER DATABASE Use the pg_basebackup utility to take the backup directory and change the the conf files. > 4) Slave postgresql.conf file > hot_standby = on > > 5) Create a recovery.conf file on the slave as follows: > standby_mode = 'on' > primary_conninfo = 'host=192.168.91.165' > > 6) start the standby database Try with the above approach. Regards, Hari Babu Fujitsu Australia -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
