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.