I made some changes in the recovery.conf for hot standby.
standby_mode = 'on'
primary_conninfo = 'host=192.168.1.22 user=user'


now i am getting the following error-

2010-12-02 02:19:44 IST LOG:  entering standby mode
2010-12-02 02:19:44 IST WARNING:  WAL was generated with wal_level=minimal,
data may be missing
2010-12-02 02:19:44 IST HINT:  This happens if you temporarily set
wal_level=minimal without taking a new base backup.
2010-12-02 02:19:44 IST FATAL:  hot standby is not possible because
wal_level was not set to "hot_standby" on the master server
2010-12-02 02:19:44 IST HINT:  Either set wal_level to "hot_standby" on the
master, or turn off hot_standby here.
2010-12-02 02:19:44 IST LOG:  startup process (PID 532) exited with exit
code 1
2010-12-02 02:19:44 IST LOG:  aborting startup due to startup process
failure


Dec  2 02:08:58 web3 postgres[930]: [1-1] FATAL:  the database system
is starting up
Dec  2 02:08:58 web3 postgres[929]: [3-1] WARNING:  WAL was generated
with wal_level=minimal, data may be missing
Dec  2 02:08:58 web3 postgres[929]: [3-2] HINT:  This happens if you
temporarily set wal_level=minimal without taking a new base backup.
Dec  2 02:08:58 web3 postgres[929]: [4-1] FATAL:  hot standby is not
possible because wal_level was not set to "hot_standby" on the master
server
Dec  2 02:08:58 web3 postgres[929]: [4-2] HINT:  Either set wal_level
to "hot_standby" on the master, or turn off hot_standby here.


I am able to connect to the master server and it is set to behave like a
primary server.

Does any one have any idea??? I am using FreeBSD 8.1 with PostgreSQL 9.0.1

-- 
Pushpendra Singh Thakur

COREEXPERTS Technologies Private Limited
Business Process Automation & IT Support Services
http://www.corexprts.com
Phone - 91-761-4070036
Fax - 91-761-4010530
SMS - 91-799-66554

pgsql-novice by date

Next:	From: Tony Day	Date: 2010-12-02 01:05:50
	Subject: Differing performance between Ubuntu 10.04 and 10.10
Previous:	From: Tom Lane	Date: 2010-12-01 17:34:53
	Subject: Re: Clarification, please