Problem with initdb

From: Frank Illner <Illner(at)lotto-brandenburg(dot)de>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem with initdb
Date: 2004-01-16 16:08:57
Message-ID: 5E5F66D95B82D711AB2D0002B3A6AAB210DB91@nt_ex.lotto-brandenburg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hi,

i try to install the pgsql versin 7.3.4. on a new computer.

The installing steps where sucsessful:
./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres

when i try to create thr db-cluster with "/usr/local/pgsql/bin/initdb -D
/usr/local/pgsql/data"
the initdb-tool shows this:
----------------------------------------------------------------------------
--------------------------
postgres(at)sgs2:/usr/local/pgsql/bin> ./initdb -d -D /usr/local/pgsql/testdata
Running with debug mode on.

initdb variables:
PGDATA=/usr/local/pgsql/testdata
datadir=/usr/local/pgsql/share
PGPATH=.
ENCODING=
ENCODINGID=0
POSTGRES_SUPERUSERNAME=postgres
POSTGRES_BKI=/usr/local/pgsql/share/postgres.bki
POSTGRES_DESCR=/usr/local/pgsql/share/postgres.description
POSTGRESQL_CONF_SAMPLE=/usr/local/pgsql/share/postgresql.conf.sample
PG_HBA_SAMPLE=/usr/local/pgsql/share/pg_hba.conf.sample
PG_IDENT_SAMPLE=/usr/local/pgsql/share/pg_ident.conf.sample
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locales:
COLLATE: C CTYPE: de_DE(at)euro MESSAGES: C
MONETARY: C NUMERIC: C TIME: C

creating directory /usr/local/pgsql/testdata... ok
creating directory /usr/local/pgsql/testdata/base... ok
creating directory /usr/local/pgsql/testdata/global... ok
creating directory /usr/local/pgsql/testdata/pg_xlog... ok
creating directory /usr/local/pgsql/testdata/pg_clog... ok
creating template1 database in /usr/local/pgsql/testdata/base/1... DEBUG:
invoking IpcMemoryCreate(size=983040)
LOG: database system was shut down at 2004-01-16 17:50:01 CET
LOG: checkpoint record is at 0/10
LOG: redo record is at 0/10; undo record is at 0/10; shutdown TRUE
LOG: next transaction id: 3; next oid: 16384
LOG: database system is ready
DEBUG: start transaction
DEBUG: creating bootstrap relation pg_proc...
DEBUG: column proname name
DEBUG: column pronamespace oid
DEBUG: column proowner int4
DEBUG: column prolang oid
DEBUG: column proisagg bool
DEBUG: column prosecdef bool
DEBUG: column proisstrict bool
DEBUG: column proretset bool
DEBUG: column provolatile char
DEBUG: column pronargs int2
DEBUG: column prorettype oid
DEBUG: column proargtypes oidvector
DEBUG: column prosrc text
DEBUG: column probin bytea
DEBUG: column proacl _aclitem
DEBUG: commit transaction
DEBUG: start transaction
DEBUG: bootstrap relation created
DEBUG: commit transaction
DEBUG: start transaction
DEBUG: inserting row with oid 1242...
DEBUG: inserting column 0 value 'boolin'
DEBUG: Typ == NULL, typeindex = 3
./initdb: line 582: 9677 Segmentation fault "$PGPATH"/postgres -boot
-x1 $PGSQL_OPT $BACKEND_TALK_ARG template1

initdb failed.
Removing /usr/local/pgsql/testdata.
----------------------------------------------------------------------------
--------------------------

Since three last month runs the same version on an other computer fine.
The mashines are running under "suse 8.2". It was never a problem...

The new computer is very fast with 2 proc 2.6 GHz, 2 GB Ram and
IDE-RAID-Set...but i think it should be a problem for the db.?

Please, can you help me??

best regards from germany

Frank Illner
____________________________________________________________

Teamleiter Enwicklung-Neue Medien / Abteilung IT
LAND BRANDENBURG LOTTO GmbH
Steinstraße 104 - 106; 14480 Potsdam
Tel.: +49 (0) 331 / 64 56 424; Fax: +49 (0) 331 / 64 56 401
email: illner(at)lotto-brandenburg(dot)de
visit http://www.lotto-brandenburg.de
____________________________________________________________

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-01-16 18:26:03 BUG #1051: Cannot remove groups
Previous Message mauro.folcarelli 2004-01-16 11:20:41 pg_connect(): Cannot create new link. Too many open links (0)