On 06/28/10 11:41 AM, Geoffrey wrote:
> 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??? Running as the
> postgres user.
>
> Any assistance would be appreciated.
maybe he did an "su postgres" and not a "su - postgres" ? the latter
does the equiv of a login, while the first only changes hte effective user.