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

initdb fails at initializing pg_shadow

From: Joerg Brandt <jbrandt(at)math(dot)uni-bremen(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: initdb fails at initializing pg_shadow
Date: 2001-05-10 15:00:01
Message-ID: 200105101500.f4AF02o03128@zeus.math.uni-bremen.de (view raw or flat)
Thread:
Lists: pgsql-admin
Is the following a bug or my mistake -- any hints?

The system:
$ uname -a
SunOS euklid 5.8 Generic_108528-03 sun4u sparc SUNW,Ultra-4

The user:
$ id
uid=440(postgres) gid=177(postgres)

The problem:
$ initdb -D /export/home/data/postgres -d
Running with debug mode on.

Initdb variables:
  PGDATA=/export/home/data/postgres
  datadir=/opt/pgsql/share
  PGPATH=/opt/pgsql/bin
  TEMPFILE=/tmp/initdb.11243
  MULTIBYTE=
  MULTIBYTEID=0
  POSTGRES_SUPERUSERNAME=postgres
  POSTGRES_SUPERUSERID=440
  TEMPLATE1_BKI=/opt/pgsql/share/template1.bki
  GLOBAL_BKI=/opt/pgsql/share/global.bki
  TEMPLATE1_DESCR=/opt/pgsql/share/template1.description
  GLOBAL_DESCR=/opt/pgsql/share/global.description
  POSTGRESQL_CONF_SAMPLE=/opt/pgsql/share/postgresql.conf.sample
  PG_HBA_SAMPLE=/opt/pgsql/share/pg_hba.conf.sample
  PG_IDENT_SAMPLE=/opt/pgsql/share/pg_ident.conf.sample
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.

Fixing permissions on existing directory /export/home/data/postgres
Creating directory /export/home/data/postgres/base
Creating directory /export/home/data/postgres/global
Creating directory /export/home/data/postgres/pg_xlog
Creating template1 database in /export/home/data/postgres/base/1
Running: /opt/pgsql/bin/postgres -boot -x1 -C -F -D/export/home/data/postgres -d template1
DEBUG:  database system was shut down at 2001-05-10 16:21:22 MEST
DEBUG:  CheckPoint record at (0, 8)
DEBUG:  Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE
DEBUG:  NextTransactionId: 514; NextOid: 16384
DEBUG:  database system is in production state
Creating global relations in /export/home/data/postgres/global
Running: /opt/pgsql/bin/postgres -boot -C -F -D/export/home/data/postgres -d template1
DEBUG:  database system was shut down at 2001-05-10 16:21:25 MEST
DEBUG:  CheckPoint record at (0, 72)
DEBUG:  Redo record at (0, 72); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 514; NextOid: 16384
DEBUG:  database system is in production state
<datname name> 
<datdba int4> 
<encoding int4> 
<datistemplate bool> 
<datallowconn bool> 
<datlastsysoid oid> 
<datpath text> 
> creating bootstrap relation
bootstrap relation created ok
> Commit End
tuple 1<Inserting value: 'template1'
Typ == NULL, typeindex = 3 idx = 0
template1 End InsertValue
Inserting value: '440'
Typ == NULL, typeindex = 6 idx = 1
440 End InsertValue
Inserting value: '0'
Typ == NULL, typeindex = 6 idx = 2
0 End InsertValue
Inserting value: 't'
Typ == NULL, typeindex = 0 idx = 3
t End InsertValue
Inserting value: 't'
Typ == NULL, typeindex = 0 idx = 4
t End InsertValue
Inserting value: '0'
Typ == NULL, typeindex = 9 idx = 5
0 End InsertValue
Inserting value: ''
Typ == NULL, typeindex = 8 idx = 6
 End InsertValue
Insert Begin
InsertOneTuple oid 1, 7 attrs
End InsertOneTuple, objectid=1
Insert End

> Transaction End
Amclose: relation (null).
> <varfoo oid> 

> creating bootstrap relation
bootstrap relation created ok
> Commit End
Amclose: relation (null).
> <usename name> 
<usesysid int4> 
<usecreatedb bool> 
<usetrace bool> 
<usesuper bool> 
<usecatupd bool> 
<passwd text> 
<valuntil int4> 

> creating bootstrap relation
bootstrap relation created ok
> Commit End
tuple 0<Inserting value: 'postgres'
Typ == NULL, typeindex = 3 idx = 0
postgres End InsertValue
Inserting value: '440'
Typ == NULL, typeindex = 6 idx = 1
440 End InsertValue
Inserting value: 't'
Typ == NULL, typeindex = 0 idx = 2
t End InsertValue
Inserting value: 't'
Typ == NULL, typeindex = 0 idx = 3
t End InsertValue
Inserting value: 't'
Typ == NULL, typeindex = 0 idx = 4
t End InsertValue
Inserting value: 't'
Typ == NULL, typeindex = 0 idx = 5
t End InsertValue
Inserting null
Inserting null
Insert Begin
InsertOneTuple oid 0, 8 attrs
End InsertOneTuple, objectid=0
Insert End

> Transaction End
Amclose: relation (null).
> <groname name> 
<grosysid int4> 
<grolist _int4> 

> creating bootstrap relation
bootstrap relation created ok
> Commit End
Amclose: relation (null).
> <logfoo oid> 

> creating bootstrap relation
bootstrap relation created ok
> Commit End
Amclose: relation (null).
> Initializing pg_shadow.

initdb failed.
Removing temp file /tmp/initdb.11243.

-- 
Mit freundl. Gruss --- Best Regards
------------------------------------------------------------------------
Joerg Brandt c/o University of Bremen        | Phone: (+49)-421-218-9006
Mathemathics and Computer Science Dept.      | Fax:   (+49)-421-218-4863
PO Box 330440  D-28334 Bremen  Germany       | Telex: 0245811 unibr d
Local: Building MZH  Room 2390
System and network administrator for domain math.uni-bremen.de
------------------------------------------------------------------------
My PGP 2.6 key 2048/49847939 is available searching a public keyserver.
Key fingerprint = C9 CF 41 10 65 AA 2C 9F  07 36 30 FB 89 69 6D 5A.
========================================================================
UNIX _is_ user friendly - it's just selective about who its friends are!
========================================================================



Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2001-05-10 22:24:44
Subject: Re: Cursor keys not working, repost.
Previous:From: Klaus BurkartDate: 2001-05-10 11:27:37
Subject: How to start PostgreSQL under NT

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