Error while setting up streaming replication, postgres 9.0-beta 4

--e0cb4e6ff629b30586048e825db6
Content-Type: text/plain; charset=ISO-8859-1

Hello everyone,

OS = Linux Suse, sles 11, 64-bit
Postgres version = 9.0 beta-4

I'm trying to test streaming replication. I set up a primary and secondary.
The primary starts normal, but when I start the standby, it doesn't start
up. The log looks like this:

LOG: database system was interrupted while in recovery at log time
2010-08-23 13:30:43 EDT
HINT: If this has occurred more than once some data might be corrupted and
you might need to choose an earlier recovery target.
LOG: entering standby mode
WARNING: WAL was generated with wal_level=minimal, data may be missing
HINT: This happens if you temporarily set wal_level=minimal without taking
a new base backup.
FATAL: hot standby is not possible because wal_level was not set to
"hot_standby" on the master server
HINT: Either set wal_level to "hot_standby" on the master, or turn off
hot_standby here.
LOG: startup process (PID 5875) exited with exit code 1
LOG: aborting startup due to startup process failure


Note that I have checked multiple times that 'wal_level' is set to
'hot_standby' on the primary, and the secondary has correct connection
information to the primary in 'resolve.conf'.

Any pointers?

Thanks.

--e0cb4e6ff629b30586048e825db6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello everyone,

OS =3D Linux Suse, sles 11, 64-bit
Postgres versi=
on =3D 9.0 beta-4

I'm trying to test streaming replication. I se=
t up a primary and secondary. The primary starts normal, but when I start t=
he standby, it doesn't start up. The log looks like this:


LOG:=A0 database system was interrupted while in recovery at log time 2=
010-08-23 13:30:43 EDT
HINT:=A0 If this has occurred more than once some=
data might be corrupted and you might need to choose an earlier recovery t=
arget.

LOG:=A0 entering standby mode
WARNING:=A0 WAL was generated with wal_lev=
el=3Dminimal, data may be missing
HINT:=A0 This happens if you temporari=
ly set wal_level=3Dminimal without taking a new base backup.
FATAL:=A0 h=
ot standby is not possible because wal_level was not set to "hot_stand=
by" on the master server

HINT:=A0 Either set wal_level to "hot_standby" on the master, or =
turn off hot_standby here.
LOG:=A0 startup process (PID 5875) exited wit=
h exit code 1
LOG:=A0 aborting startup due to startup process failure >


Note that I have checked multiple times that 'wal_level' is set=
to 'hot_standby' on the primary, and the secondary has correct con=
nection information to the primary in 'resolve.conf'.

Any po=
inters?


Thanks.




--e0cb4e6ff629b30586048e825db6--

Re: Error while setting up streaming replication, postgres 9.0-beta 4

fazool mein writes:
> I'm trying to test streaming replication. I set up a primary and secondary.
> The primary starts normal, but when I start the standby, it doesn't start
> up. The log looks like this:

> LOG: database system was interrupted while in recovery at log time
> 2010-08-23 13:30:43 EDT
> HINT: If this has occurred more than once some data might be corrupted and
> you might need to choose an earlier recovery target.
> LOG: entering standby mode
> WARNING: WAL was generated with wal_level=minimal, data may be missing
> HINT: This happens if you temporarily set wal_level=minimal without taking
> a new base backup.
> FATAL: hot standby is not possible because wal_level was not set to
> "hot_standby" on the master server
> HINT: Either set wal_level to "hot_standby" on the master, or turn off
> hot_standby here.
> LOG: startup process (PID 5875) exited with exit code 1
> LOG: aborting startup due to startup process failure


> Note that I have checked multiple times that 'wal_level' is set to
> 'hot_standby' on the primary,

You need to do that *before* taking your base backup. The WARNING above
indicates that the backup was taken with an inadequate wal_level
setting.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Error while setting up streaming replication, postgres9.0-beta 4

--0016e647ec6e469797048e830f02
Content-Type: text/plain; charset=ISO-8859-1

Great! I made the base backup again as you said, and its working now.
Thanks.


On Mon, Aug 23, 2010 at 12:17 PM, Tom Lane wrote:

> fazool mein writes:
> > I'm trying to test streaming replication. I set up a primary and
> secondary.
> > The primary starts normal, but when I start the standby, it doesn't start
> > up. The log looks like this:
>
> > LOG: database system was interrupted while in recovery at log time
> > 2010-08-23 13:30:43 EDT
> > HINT: If this has occurred more than once some data might be corrupted
> and
> > you might need to choose an earlier recovery target.
> > LOG: entering standby mode
> > WARNING: WAL was generated with wal_level=minimal, data may be missing
> > HINT: This happens if you temporarily set wal_level=minimal without
> taking
> > a new base backup.
> > FATAL: hot standby is not possible because wal_level was not set to
> > "hot_standby" on the master server
> > HINT: Either set wal_level to "hot_standby" on the master, or turn off
> > hot_standby here.
> > LOG: startup process (PID 5875) exited with exit code 1
> > LOG: aborting startup due to startup process failure
>
>
> > Note that I have checked multiple times that 'wal_level' is set to
> > 'hot_standby' on the primary,
>
> You need to do that *before* taking your base backup. The WARNING above
> indicates that the backup was taken with an inadequate wal_level
> setting.
>
> regards, tom lane
>

--0016e647ec6e469797048e830f02
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Great! I made the base backup again as you said, and its working now.
Th=
anks.