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
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 |