Re: HOT standby on windows not working

On Fri, Apr 11, 2014 at 8:15 AM, CS_DBA <cs_dba(at)consistentstate(dot)com> 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