postgres 9 streaming replication

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

Responses

Browse pgsql-bugs by date

  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