postgresql startup

On 12/8/07, Charles <post@upyours.us> wrote:

I am using Ubuntu 7.10. When trying to use Postgresql 8.2 I get the
following errors:

root@DagonUX32:~# su -c postgres
bash: postgres: command not found

Ignoring an error and just charging on seems quite dangerous to me,
especially when being root.

But that aside, try 'su - postgres' (so just a minus, not -c).

root@DagonUX32:~# createuser -s -P dagon
Enter password for new role:
Enter it again:
createuser: could not connect to database postgres: FATAL: role "root"
does not exist

I have done a complete removal of postgresql, then resinstalled. I still
get the same error. Is there a configuration file somewhere that needs
to be removed? (I did make sure that /etc/postgresql was deleted.

All the help I can get will be appreciated!

Thanks.

Charles

jan