Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group