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

Reply via email to