Re: could not change directory to "/root" - Mailing list pgsql-novice

From Tom Lane
Subject Re: could not change directory to "/root"
Date
Msg-id 12720.1280260751@sss.pgh.pa.us
Whole thread Raw
In response to could not change directory to "/root"  (viju <ace_of_blackstar@yahoo.com>)
List pgsql-novice
viju <ace_of_blackstar@yahoo.com> writes:
> I am new to postgresql.� I am having some weird problems.
> Output
>  attached below.� Please any help would be appreciated.

> bash-3.2$
>  createdb test1
> could not change directory to "/root"
> bash-3.2$
> dropdb test
> could not change directory to "/root"
> bash-3.2$

Apparently you did "su postgres" from the root account, so you're
still in root's home directory.  It'd be better to do "su - postgres"
to ensure you've acquired all of the postgres account's environment.
Reading "man su" might help you out here.

            regards, tom lane

pgsql-novice by date:

Previous
From: Lew
Date:
Subject: Re: Select only active entries
Next
From: Michael Wood
Date:
Subject: Re: ORDER BY with UNION