Skip site navigation (1) Skip section navigation (2)


From: "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] BLCKSZ 0?
Date: 2001-02-28 15:28:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-hackers
On Tue, 27 Feb 2001, Tom Lane wrote:

> "Dominic J. Eidson" <sauron(at)the-infinite(dot)org> writes:
> > root(at)blue:/usr/local/pgsql# su postgres -c "bin/postmaster -D
> > /usr/local/pgsql/data "
> > DEBUG:  Data Base System is starting up at Tue Feb 27 22:31:51 2001
> > FATAL 2:  database was initialized with BLCKSZ 0,
> >         but the backend was compiled with BLCKSZ 8192.
> >         looks like you need to initdb.
> Read that again --- it did *not* say it was compiled with BLCKSZ 0.
> It said (or meant, anyway) it found zero in the pg_control field that
> indicates the BLCKSZ in use in the database.  Something's broken with
> your pg_control file ... care to give more details?

Admin installed PostgreSQL 7.0(.x?) - clueless coder comes along sometime
later, decides to install 6.5.3, because debian apt-get doesn't have
7.0(.x) yet. Doesn't pg_dumpall, doesn't back up anyting (not even just a
tar of /usr/local/pgsql) Believing he lost all of his DB setup, admin
contacts me to try to get things back up and running. He claims apt-get
installed the binaries in a different place (and assumes .deb package
installs the data directory elsewhere as well.) So I tried to start up the
DB using the (supposedly) old/original binaries, and the old data
directory, which is when I get the above message(s).

Dominic J. Eidson
                                        "Baruk Khazad! Khazad ai-menu!" - Gimli

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2001-02-28 15:39:26
Subject: Re: [HACKERS] BLCKSZ 0?
Previous:From: Tom LaneDate: 2001-02-28 15:18:50
Subject: Re: [HACKERS] strange error

pgsql-general by date

Next:From: Tom LaneDate: 2001-02-28 15:39:26
Subject: Re: [HACKERS] BLCKSZ 0?
Previous:From: Mark StosbergDate: 2001-02-28 15:22:20
Subject: trouble configuring Postgres with Identd authentication

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group