Not overly familiar with how Ubuntu handles postgres, but try
to "su - postgres" to begin with. The obvious problem you're
facing is that your postgres user doesn't have permission to
be in the directory in which you are trying to do stuff.
Switching with '-' will put you in postgres' home.
A bit of googling suggests that ubuntu uses /etc/init.d/postgresql-X.Y
for startup ...
Last edited by Tinkster; 08-02-2010 at 12:45 AM.