From: | akp geek <akpgeek(at)gmail(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: setting up streaming error. Please help |
Date: | 2011-06-10 20:13:34 |
Message-ID: | BANLkTinEJcg4giDVTisx9QJtr6jhBD52kw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Both the servers are having 9.0.2
Thanks
On Fri, Jun 10, 2011 at 4:09 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info>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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chrishelring | 2011-06-10 20:45:46 | Problems with to_number |
Previous Message | Guillaume Lelarge | 2011-06-10 20:09:21 | Re: setting up streaming error. Please help |