recent (just got from cvs) build doesn't run nicely - Mailing list pgsql-bugs

From Hubert depesz Lubaczewski
Subject recent (just got from cvs) build doesn't run nicely
Date
Msg-id 20030127203833.GA26087@depesz.pl
Whole thread Raw
Responses Re: recent (just got from cvs) build doesn't run nicely  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
hi
i just got newest checkout from cvs.
it builded fine.
it installed. than i do initdb:
(pgdba@depeszws[pts/11]) 21:35:05 [~]
$ echo $PGDATA
/home/pgdba/work/data

(pgdba@depeszws[pts/11]) 21:35:10 [~]
$ initdb -W
The files belonging to this database system will be owned by user "pgdba".
This user must also own the server process.

The database cluster will be initialized with locale C.

Fixing permissions on existing directory /home/pgdba/work/data... ok
creating directory /home/pgdba/work/data/base... ok
creating directory /home/pgdba/work/data/global... ok
creating directory /home/pgdba/work/data/pg_xlog... ok
creating directory /home/pgdba/work/data/pg_clog... ok
creating template1 database in /home/pgdba/work/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
Enter new superuser password:
Enter it again:
setting password... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... /home/pgdba/work/bin/initdb: line 716: 26438 Segmentation fault      "$PGPATH"/postgres
$PGSQL_OPTtemplate1 >/dev/null  <<EOF 
-- Make PIN entries in pg_depend for all objects made so far in the tables
-- that the dependency code handles.  This is overkill (the system doesn't
-- really depend on having every last weird datatype, for instance)
-- but generating only the minimum required set of dependencies seems hard.
-- Note that we deliberately do not pin the system views.
-- First delete any already-made entries; PINs override all else, and must
-- be the only entries for their objects.
DELETE FROM pg_depend;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_class;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_proc;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_type;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_cast;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_constraint;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_attrdef;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_language;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_operator;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_opclass;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_rewrite;
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_trigger;
-- restriction here to avoid pinning the public namespace
INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_namespace     WHERE nspname LIKE 'pg%';
EOF


initdb failed.

despite the fact that initdb failed, i actually *can* start postmaster:
$ pg_ctl start
pg_ctl: Another postmaster may be running.  Trying to start postmaster anyway.
LOG:  database system was interrupted at 2003-01-27 21:35:24 CET
LOG:  checkpoint record is at 0/4A944
LOG:  redo record is at 0/4A944; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 23; next oid: 16682
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 0/4A984
LOG:  ReadRecord: invalid magic number 0000 in log file 0, segment 0, offset 786432
LOG:  redo done at 0/BFFB0
postmaster successfully started
LOG:  database system is ready

but, when i'll try to use psql:

$ psql template1
ERROR:  Relation "pg_catalog"."pg_user" does not exist
ERROR:  Relation "pg_catalog"."pg_user" does not exist
Welcome to psql 7.4devel, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=>


do you have any idea on what is wrong?

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
>  wynajmê mieszkanie - 60 metrów, 3 pokoje, piastów - od lutego (po   <
-=>       remoncie) interesuje ciê - napisz: depesz@depesz.pl        <=-

pgsql-bugs by date:

Previous
From: Josh Berkus
Date:
Subject: Re: No migration path for MONEY
Next
From: Peter Eisentraut
Date:
Subject: Re: Bug #880: COMMENT ON DATABASE depends on current database