From: | "Khadtare, Sharad" <sharad(dot)khadtare(at)teamaol(dot)com> |
---|---|
To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | postgres 9 streaming replication |
Date: | 2011-01-25 08:01:08 |
Message-ID: | 951D39B8B6185A4D852967EB943E7AE701CEA042@AOLE1AMEC31.ad.aol.aoltw.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
Configured postgres 9 streaming replication and changed parameter in postgresql.conf & pg_hba.conf file
Problem is wal sender & receiver process not started , is there any way to check process please suggest.
172.21.132.1 ( primary )
172.18.221.211 ( standby )
pg_hba.conf (primary & standby )
host replication all 172.18.221.211 255.255.255.255 trus
recovery.conf ( standby )
standby_mode = 'on'
primary_conninfo = 'host=172.21.132.1 port=5432 user=repusr'
trigger_file = '/db/postgres/trigger'
restore_command = 'cp -f /db/postgres/data/pg_wal/%f %p < /dev/null '
postgresql.conf ( primary )
listen_addresses = '*'
port = 5432
archive_mode = on
archive_command = 'cp "%p" /db/postgres/data/pg_wal/"%f" < /dev/null'
max_wal_senders = 3
wal_level = hot_standby
postgresql.conf ( standby )
listen_addresses = '*'
port = 5432
archive_mode = on
archive_command = 'cp "%p" /db/postgres/data/pg_wal/"%f" < /dev/null'
max_wal_senders = 3
wal_level = hot_standby
hot_standby = on
From | Date | Subject | |
---|---|---|---|
Next Message | tushar | 2011-01-25 10:05:56 | Re: postgres 9 streaming replication |
Previous Message | SETU SAXENA | 2011-01-25 06:31:06 | A bug to report |