initdb - segmentation failed

Поиск
Список
Период
Сортировка
От Dmitry Pletnev
Тема initdb - segmentation failed
Дата
Msg-id 36AEB126.C372587C@ccl.ru
обсуждение исходный текст
Список pgsql-admin
Hi!
I am a problem with use postgress 6.4.2 on bsdi 2.1

gmake all
and
gmake install work correctly.

But first initdb displayed:


We are initializing the database system with username postgres
(uid=136).
This user will own all the files and must also own the server process.

Creating Postgres database system directory /usr/local/pgsql/data

Creating Postgres database system directory /usr/local/pgsql/data/base

Creating template database in /usr/local/pgsql/data/base/template1

Creating global classes in /usr/local/pgsql/data/base

Adding template1 database to pg_database...

Vacuuming template1
Segmentation failed - core dumped


And if I add in initdb

"set -x"

and remove "-o /dev/null" form argument of postgres and run initdb, I
see:
+ basename /usr/local/pgsql/bin/initdb
+ CMDNAME=initdb
+ MULTIBYTEID=0
+ MULTIBYTE=
+ [ -n  ]
+ sh -c postconfig
+ postconfig_result=
+ [ ! -z  ]
+ debug=0
+ noclean=0
+ template_only=0
+ POSTGRES_SUPERUSERNAME=postgres
+ [ 0 -gt 0 ]
+ [ -z /usr/local/pgsql/lib ]
+ [ -z /usr/local/pgsql/data ]
+ TEMPLATE=/usr/local/pgsql/lib/local1_template1.bki.source
+ GLOBAL=/usr/local/pgsql/lib/global1.bki.source
+ TEMPLATE_DESCR=/usr/local/pgsql/lib/local1_template1.description
+ GLOBAL_DESCR=/usr/local/pgsql/lib/global1.description
+ PG_HBA_SAMPLE=/usr/local/pgsql/lib/pg_hba.conf.sample
+ PG_GEQO_SAMPLE=/usr/local/pgsql/lib/pg_geqo.sample
+ [ ! -f /usr/local/pgsql/lib/local1_template1.bki.source ]
+ [ ! -f /usr/local/pgsql/lib/global1.bki.source ]
+ [ ! -f /usr/local/pgsql/lib/pg_hba.conf.sample ]
+ [ 0 -ne 0 ]
+ [ 0 -eq 0 ]
+ [ 0 -ne 0 ]
+ [ 0 -ne 0 ]
+ echo

+ [ -z postgres ]
+ pg_id postgres
+ POSTGRES_SUPERUID=136
+ [ 136 -eq -1 ]
+ [ 136 = NOUSER ]
+ pg_id
+ pg_id
+ [ 136 -ne 136 -a 136 -ne 0 ]
+ echo We are initializing the database system with username postgres
(uid=136).
We are initializing the database system with username postgres
(uid=136).
+ echo This user will own all the files and must also own the server
process.
This user will own all the files and must also own the server process.
+ echo

+ umask 077
+ [ -f /usr/local/pgsql/data/PG_VERSION ]
+ [ ! -d /usr/local/pgsql/data ]
+ echo Creating Postgres database system directory /usr/local/pgsql/data

Creating Postgres database system directory /usr/local/pgsql/data
+ echo

+ mkdir /usr/local/pgsql/data
+ [ 0 -ne 0 ]
+ [ ! -d /usr/local/pgsql/data/base ]
+ echo Creating Postgres database system directory
/usr/local/pgsql/data/base
Creating Postgres database system directory /usr/local/pgsql/data/base
+ echo

+ mkdir /usr/local/pgsql/data/base
+ [ 0 -ne 0 ]
+ rm -rf /usr/local/pgsql/data/base/template1
+ mkdir /usr/local/pgsql/data/base/template1
+ [ 0 -eq 1 ]
+ BACKEND_TALK_ARG=-Q
+ BACKENDARGS=-boot -C -F -D/usr/local/pgsql/data -Q
+ echo Creating template database in
/usr/local/pgsql/data/base/template1
Creating template database in /usr/local/pgsql/data/base/template1
+ [ 0 -ne 0 ]
+ cat /usr/local/pgsql/lib/local1_template1.bki.source
+ sed -e s/postgres PGUID/postgres 136/ -e s/PGUID/136/
+ postgres -boot -C -F -D/usr/local/pgsql/data -Q template1
+ [ 0 -ne 0 ]
+ echo

+ pg_version /usr/local/pgsql/data/base/template1
+ [ 0 -eq 0 ]
+ echo Creating global classes in /usr/local/pgsql/data/base
Creating global classes in /usr/local/pgsql/data/base
+ [ 0 -ne 0 ]
+ cat /usr/local/pgsql/lib/global1.bki.source
+ sed -e s/postgres PGUID/postgres 136/ -e s/PGUID/136/
+ postgres -boot -C -F -D/usr/local/pgsql/data -Q template1
+ test 0 -ne 0
+ echo

+ pg_version /usr/local/pgsql/data
+ cp /usr/local/pgsql/lib/pg_hba.conf.sample
/usr/local/pgsql/data/pg_hba.conf
+ cp /usr/local/pgsql/lib/pg_geqo.sample
/usr/local/pgsql/data/pg_geqo.sample
+ echo Adding template1 database to pg_database...
Adding template1 database to pg_database...
+ echo open pg_database
+ echo insert (template1 136 0 template1)
+ echo close pg_database
+ [ 0 -ne 0 ]
+ postgres -boot -C -F -D/usr/local/pgsql/data -Q template1
+ [ 0 -ne 0 ]
+ rm -f /tmp/create.18748
+ echo

+ PGSQL_OPT=-o /dev/null -F -Q -D/usr/local/pgsql/data
+ echo Vacuuming template1
Vacuuming template1
+ echo vacuum
+ postgres -o /dev/null -F -Q -D/usr/local/pgsql/data template1
+ echo COPY pg_shadow TO '/usr/local/pgsql/data/pg_pwd' USING DELIMITERS
'\t'
+ postgres -F -Q -D/usr/local/pgsql/data template1
ERROR:  parser: syntax error at or near "pg_shadow"
ERROR:  parser: syntax error at or near "pg_shadow"
^^^^^^^???

Where my error? Help me please


--
Dmitry Pletnev, Perm Russia


В списке pgsql-admin по дате отправления:

Предыдущее
От: Postgres GOD
Дата:
Сообщение: Re: [ADMIN] configuring pg_hba.conf...
Следующее
От: "Reiner Nippes"
Дата:
Сообщение: [ADMIN] Running Postgres on a HP-Ux 10.10 System