Thread: postgresql-7.1beta1 initdb error

postgresql-7.1beta1 initdb error

From
"James McMurry"
Date:
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

From
Peter Eisentraut
Date:
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/