Postgresql error FATAL: user "root" does not exist"
 

Hi
I'm using kUbuntu.
using the package manager I installed Postgresql.

When my PC boots up I see it (Postgresql) loadup.

When I try to add a user of create a database I get an error.

For example when I try to create a database:
cgetty@clark:~$ sudo -s -H
createdb mydb

I get this
"createdb: could not connect to database template1: FATAL: user "root" does not exist"

Any one have any ideas ?

Thanks
Clark

[google]
1. Ubuntu disables the root user account by default. To enable it, open up a console and type sudo and then your regular user's password. Then type passwd root to set the root user's password. You should now be able to log in as root.

OR

2. To set the root password use this command
sudo passwd
It will first prompt for a password, this is your user's password. Then it will ask you the password to set for root. After you set the password, you can then login as root or su to root.
[/google]

enable the root, then try again.

actually, the topic is at
http://www.linuxforums.org/forum/ptopic44799.html

mustafa

I tried both options with no success.
 

Hi elsheikhmh

I tried both options with no success.

Option 1
cgetty@clark:~$ passwd root
passwd: You may not view or modify password information for root.


Option 2
I think that just changed the password for the current user.

Thanks for responding

I'm sure there is a work around, I just need to find it.

Clark

You forgot to during the first option.

thanks, I'll try it.
Clark