Hot standby

Поиск
Список
Период
Сортировка
От Pushpendra Singh Thakur
Тема Hot standby
Дата
Msg-id AANLkTi=JBFmZOGXOvLqwrqih_xfDstrwPbqcPg5i7mON@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Clarification, please
Следующее
От: Tony Day
Дата:
Сообщение: Differing performance between Ubuntu 10.04 and 10.10