Both the servers are having 9.0.2 Thanks
On Fri, Jun 10, 2011 at 4:09 PM, Guillaume Lelarge <guilla...@lelarge.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 > >
