Обсуждение: Hot standby

Поиск
Список
Период
Сортировка

Hot standby

От
Pushpendra Singh Thakur
Дата:
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