viju <ace_of_blackstar(at)yahoo(dot)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