i'm trying to create a new user in postgres (createuser [user]), but when logged in as root or any other user, i get "permission denied". i tried to "su postgres", but it prompts me for the password, which seems to have been set by default by mandrake. does anyone know what it is? if i log in as root and 1) change the password or 2) remove the postgres user and create a new one with a new password, will the postgres startup service still work?
thank you very much, a linux and postgres newbie...
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com