Re: could not change directory to "/root"

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