postgresql-7.1beta1 initdb error
postgresql-7.1beta1 initdb error
От:
"James McMurry" <jmcmurry@pobox.com>
Дата:
Hi, I'm working with postgresql-7.1beta1 on Solaris 8, and I get this error when running initdb as the "postgres" user: ----- $ initdb -D /opt/pgsql/data -W 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 /opt/pgsql/data Creating directory /opt/pgsql/data/base Creating directory /opt/pgsql/data/global Creating directory /opt/pgsql/data/pg_xlog Creating template1 database in /opt/pgsql/data/base/1 DEBUG: starting up DEBUG: database system was shut down at 2001-01-04 09:01:57 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 /opt/pgsql/data/global DEBUG: starting up DEBUG: database system was shut down at 2001-01-04 09:02:07 DEBUG: CheckPoint record at (0, 96) DEBUG: Redo record at (0, 96); Undo record at (0, 0); Shutdown TRUE DEBUG: NextTransactionId: 514; NextOid: 17199 DEBUG: database system is in production state Initializing pg_shadow. Enter new superuser password: Enter it again: The password file wasn't generated. Please report this problem. initdb failed. Removing temp file /tmp/initdb.3200. ----- To whom should I report the error? And does anyone have a suggestion? I'm new to PostgreSQL, so it's possible I've done something obviously wrong. Thanks!
Re: postgresql-7.1beta1 initdb error
От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
James McMurry writes:
> Enter new superuser password:
> Enter it again:
> The password file wasn't generated. Please report this problem.
Please apply to following patch to src/bin/initdb.sh:
diff -c -r1.118 initdb.sh
*** initdb.sh 2000/12/31 22:24:14 1.118
--- initdb.sh 2001/01/04 16:10:43
***************
*** 533,539 ****
fi
echo "ALTER USER \"$POSTGRES_SUPERUSERNAME\" WITH PASSWORD '$FirstPw'" \
| "$PGPATH"/postgres $PGSQL_OPT template1 > /dev/null || exit_nicely
! if [ ! -f $PGDATA/pg_pwd ]; then
echo "The password file wasn't generated. Please report this problem." 1>&2
exit_nicely
fi
--- 533,539 ----
fi
echo "ALTER USER \"$POSTGRES_SUPERUSERNAME\" WITH PASSWORD '$FirstPw'" \
| "$PGPATH"/postgres $PGSQL_OPT template1 > /dev/null || exit_nicely
! if [ ! -f $PGDATA/global/pg_pwd ]; then
echo "The password file wasn't generated. Please report this problem." 1>&2
exit_nicely
fi
Or you can just set the superuser password later if you're not up to
patching.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/