Tom Lane wrote:
Geoffrey <lists@xxxxxxxxxxxxxxxxxxxxx> writes:
I wrote a script that creates a new database from an existing backup.
Works great on my machine. Another user tries to use it and sees the
following output from initdb:
could not change directory to "/root"
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
.
.
Why is it trying to change directory to /root???
IIRC, part of the startup process involves chdir'ing to where the initdb
executable is and then chdir'ing back to whatever directory had been
current when you called initdb. I speculate the other guy was root and
did "su postgres" not "su - postgres", so his cwd was still root's home
directory.
This might be harmless as long as you gave an absolute path for PGDATA
to initdb, but I'd still recommend using su - not just su.
Appears this was exactly the case. I do specify absolute path for
PGDATA, thanks.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
