Initdb error - Mailing list pgsql-hackers

From Magnus Hagander
Subject Initdb error
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE1716CB@algol.sollentuna.se
Whole thread Raw
List pgsql-hackers
Hi!

I'm getting this error whenever I try to change the superuser of my
database to anything != postgres.

The same error shows up if I do "-U <someuser>" on Unix and "someuser"
does not exist in /etc/passwd. Probably the same reason - since win32
will not have any users in /etc/passwd..

It works on 7.4, so probably related to the initdb-in-C rewrite?

//Magnus



d:\msys\1.0\local\pgsql\bin>initdb -D d:\pgtemp -U pgsuper
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale
Swedish_Sweden.1252.

creating directory d:/pgtemp ... ok
creating directory d:/pgtemp/global ... ok
creating directory d:/pgtemp/pg_xlog ... ok
creating directory d:/pgtemp/pg_clog ... ok
creating directory d:/pgtemp/pg_subtrans ... ok
creating directory d:/pgtemp/base ... ok
creating directory d:/pgtemp/base/1 ... ok
creating directory d:/pgtemp/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in d:/pgtemp/base/1 ... ok
initializing pg_shadow ... ok
enabling unlimited row size for system tables ... ok
initializing pg_depend ... ok
creating system views ... ok
loading pg_description ... ok
creating conversions ... ok
setting privileges on built-in objects ... ERROR:  user "pgsuper" does
not exist

child process was terminated by signal 1
initdb: failed
initdb: removing data directory "d:/pgtemp"


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: LinuxTag wrapup
Next
From: Andreas Pflug
Date:
Subject: Re: LinuxTag wrapup