On Thu Jan 23, 2003 at 02:12:18PM +0200, Buchan Milne wrote: > > Yes there is a bug in bugzilla for that. The problem is not mysql specific > > and I have it with postgresql too. > > > > Postgres works for me: > > [bgmilne:~]# grep ^group /etc/nsswitch.conf > group: files ldap nisplus nis winbind3 > [bgmilne:~]# service postgresql start > Starting postgresql service: [ OK ] > [bgmilne:~]# service postgresql status > postmaster (pid 7808) is running... > 7807 (pid 7805) is running... > > I don't use postgres much, so don't even know how to create a db, but > createuser is failing: > > [bgmilne:~]# createuser root > Shall the new user be allowed to create databases? (y/n) y > Shall the new user be allowed to create more new users? (y/n) y > psql: FATAL: user "root" does not exist > createuser: creation of user "root" failed > > But that could just be my lack of experience with postgres. > > Any way we can debug this?
Ummm... been a while since I've used postgres, but you can't do this as root until root has an account. su - postgres first, then do the createuser stuff. That should work. -- MandrakeSoft Security; http://www.mandrakesecure.net/ "lynx -source http://linsec.ca/vdanen.asc | gpg --import" {FE6F2AFD : 88D8 0D23 8D4B 3407 5BD7 66F9 2043 D0E5 FE6F 2AFD}
msg87720/pgp00000.pgp
Description: PGP signature
