Hot standby - Mailing list pgsql-novice

From Pushpendra Singh Thakur
Subject Hot standby
Date
Msg-id AANLkTi=JBFmZOGXOvLqwrqih_xfDstrwPbqcPg5i7mON@mail.gmail.com
Whole thread Raw
List pgsql-novice
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:

Previous
From: Tom Lane
Date:
Subject: Re: Clarification, please
Next
From: Tony Day
Date:
Subject: Differing performance between Ubuntu 10.04 and 10.10