Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: tusharDate: 2011-01-25 10:05:56
Subject: Re: postgres 9 streaming replication
Previous:From: SETU SAXENADate: 2011-01-25 06:31:06
Subject: A bug to report

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group