Help installing postgres in ubuntu

Question

I'm trying to install postgresql in the latest ubunutu, and I'm following these instructions. When I sudo -u postgres psql postgres I get this error: could not change directory to "/home/james"

I'd appreciate any help.

Answer 1

It sounds like the user postgres, which you are using to run psql, may not read the directory you are executing the statement from (/home/james/)

• sudo = s witch u ser and do - sw
• u = "as user"
• postgres = user to switch to
• psql = command to execute
• postgres = database to connect to

i'm guessing here, but i think sudo will open a new shell/environment in the current dir for postgres and execute psql there. If psql is not allowed to read the current dir, this error may occur.

try to switch the directory before executing the command:

cd /tmp