postgresql-7.1beta1 initdb error
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!
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
fiOr 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/