Hot standby

From: Pushpendra Singh Thakur <thakur(at)corexprts(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Hot standby
Date: 2010-12-01 21:05:31
Message-ID: AANLkTi=JBFmZOGXOvLqwrqih_xfDstrwPbqcPg5i7mON@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

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