From: | Hubert depesz Lubaczewski <depesz(at)depesz(dot)pl> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | recent (just got from cvs) build doesn't run nicely |
Date: | 2003-01-27 20:38:33 |
Message-ID: | 20030127203833.GA26087@depesz.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
hi
i just got newest checkout from cvs.
it builded fine.
it installed. than i do initdb:
(pgdba(at)depeszws[pts/11]) 21:35:05 [~]
$ echo $PGDATA
/home/pgdba/work/data
(pgdba(at)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_OPT template1 >/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(at)depesz(dot)pl <=-
From | Date | Subject | |
---|---|---|---|
Next Message | joost | 2003-01-27 20:53:27 | year and weeknumbers (proposal included) |
Previous Message | Josh Berkus | 2003-01-27 20:21:38 | Re: No migration path for MONEY |