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 по дате отправления: