Re: setting up streaming error. Please help

[akp geek <akpgeek@xxxxxxxxx>]

Both the servers are having 9.0.2

Thanks

On Fri, Jun 10, 2011 at 4:09 PM, Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote:

On Fri, 2011-06-10 at 15:46 -0400, akp geek wrote:
> 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'
>

You miss at least the max_wal_senders parameter.

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

Are they both 9.0 servers?


--
Guillaume
 http://blog.guillaume.lelarge.info
 http://www.dalibo.com