setting up streaming error. Please help

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: setting up streaming error. Please help
Date: 2011-06-10 19:46:52
Message-ID: BANLkTim-SCOUM-8DeNjudfaWi22VJ2LHBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all -

After making the required changes to the Primary and slave , I have
restarted the slave and I keep seeing the following in the logs.

Operating system is solaris.

on the primary . postgresql.conf has the following changes

listen_addresses = '*'
port = 5432
wal_level = hot_standby
archive_mode = on
archive_command = 'cp -i %p /dbbackup/9.0.2/archive/%f
</dev/null'

pg_hba.conf ( Primary ) . created a superuser called stream on
the primary

host replication stream 10.xxx.xxx.47/32
md5

I have made the following changes on the slave

postgresql.conf ( slave )

listen_addresses = '*'
port = 5433

recovery.conf

standby_mode='on'
primary_conninfo='host=10.xxx.xxx.46 port=5432 user=stream
password=stream'

trigger_file='/opt/postgres/9.0.2/data/finished.replication'
restore_command = 'cp -i /dbbackup/9.0.2/archive/%f "%p"
</dev/null'

then restarted the slave and I see the following in logs.

*cp: cannot access /dbbackup/9.0.2/archive/00000001000000010000008E*
*FATAL: could not connect to the primary server: invalid connection option
"replication"*

Thanks for the help

regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2011-06-10 19:58:19 Re: change sample size for statistics
Previous Message Merlin Moncure 2011-06-10 19:45:54 Re: waiting for notfications on the server