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