Re: [HACKERS] BLCKSZ 0?

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
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/