Thread: Bug Report: 7.1.3 initdb fails on FreeBSD 4.4-RELEASE/Alpha

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Jeff Duffy
Your email address      : jeff@alanne.com


System Configuration
---------------------
  Architecture (example: Intel Pentium)         : AlphaStation 225
("Avanti")

  Operating System (example: Linux 2.0.26 ELF)  : FreeBSD 4.4-RELEASE

  PostgreSQL version (example: PostgreSQL-7.1.3): PostgreSQL-7.1.3

  Compiler used (example:  gcc 2.95.2)          : gcc 2.95.3


Please enter a FULL description of your problem:
------------------------------------------------
PostgreSQL was compiled from source using the following flags:
--enable-syslog --prefix=/var/pgsql

 After installation, attempting to perform an initdb as user postgres
with the command

$ /var/pgsql/bin/initdb -D /var/pgsql/data

produces the following output:

This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.

Creating directory /var/pgsql/data
Creating directory /var/pgsql/data/base
Creating directory /var/pgsql/data/global
Creating directory /var/pgsql/data/pg_xlog
Creating template1 database in /var/pgsql/data/base/1
FATAL 2:  control file context is broken

initdb failed.
Removing /var/pgsql/data.
Removing temp file /tmp/initdb.47749.
Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

Perform an initdb using a postgreSQL 7.1.3 installation on
FreeBSD 4.4-RELEASE/Alpha.

"Jeff Duffy" <jeff@alanne.com> writes:
> Creating template1 database in /var/pgsql/data/base/1
> FATAL 2:  control file context is broken

Hmm.  The only prior report I've seen of that error message was from
someone whose system clock was several decades off (there's a
not-very-well-considered test of the timestamp range included in that
check in 7.1.* :-().

If that's not it, please compile up the contrib/pg_controldata utility
and see what it prints out.

            regards, tom lane

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Friday, October 19, 2001 10:43 AM
> To: Jeff Duffy
> Cc: pgsql-ports@postgresql.org
> Subject: Re: [PORTS] Bug Report: 7.1.3 initdb fails on FreeBSD
> 4.4-RELEASE/Alpha
>
>
> "Jeff Duffy" <jeff@alanne.com> writes:
> > Creating template1 database in /var/pgsql/data/base/1
> > FATAL 2:  control file context is broken
>
> Hmm.  The only prior report I've seen of that error message was from
> someone whose system clock was several decades off (there's a
> not-very-well-considered test of the timestamp range included in that
> check in 7.1.* :-().


caemlyn$ date
Sat Sep 13 09:57:12 EST 1913

Setting the date correctly fixed the problem.

Thanks.

Jeff