Re: could not change directory to "/root"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: viju <ace_of_blackstar(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: could not change directory to "/root"
Date: 2010-07-27 19:59:11
Message-ID: 12720.1280260751@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Wood 2010-07-27 21:19:35 Re: ORDER BY with UNION
Previous Message Lew 2010-07-27 12:32:38 Re: Select only active entries