initdb fails at initializing pg_shadow
От | Joerg Brandt |
---|---|
Тема | initdb fails at initializing pg_shadow |
Дата | |
Msg-id | 200105101500.f4AF02o03128@zeus.math.uni-bremen.de обсуждение исходный текст |
Ответы |
Re: initdb fails at initializing pg_shadow
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | 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! ========================================================================
В списке pgsql-admin по дате отправления: