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!
========================================================================