On 12/8/07, Charles <post@xxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
