Go Job Hunting at the LQ Job Marketplace
Go Back > Forums > Linux Forums > Linux - Distributions > Ubuntu
User Name
Ubuntu This forum is for the discussion of Ubuntu Linux.


  Search this Thread
Old 06-21-2005, 02:09 AM   #1
LQ Newbie
Registered: Apr 2005
Posts: 5

Rep: Reputation: 0
Postgresql error FATAL: user "root" does not exist"

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 ?

Old 06-21-2005, 03:57 AM   #2
Registered: Aug 2004
Location: Cairo, Egypt
Distribution: Slackware
Posts: 101

Rep: Reputation: 15
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.


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.

enable the root, then try again.

actually, the topic is at

Old 06-21-2005, 11:19 AM   #3
LQ Newbie
Registered: Apr 2005
Posts: 5

Original Poster
Rep: Reputation: 0
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.

Old 06-21-2005, 01:43 PM   #4
Registered: Jun 2005
Location: here
Distribution: Ubuntu, maintain a Vector Linux install
Posts: 50

Rep: Reputation: 15
You forgot to
during the first option.
Old 06-21-2005, 03:11 PM   #5
LQ Newbie
Registered: Apr 2005
Posts: 5

Original Poster
Rep: Reputation: 0
thanks, I'll try it.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
what can i do with this promt"user machbuild does not exist - using root" wucheng Linux - Newbie 2 01-17-2011 08:41 AM
newbie question: whats the difference between "su root", "su" and "su -&quo mojarron Slackware 9 12-07-2009 05:08 PM
psql: FATAL 1: IDENT authentication failed for user "postgres" linuxtesting2 Linux - General 3 06-16-2004 01:48 PM
RH9 NIS login error: "home directory does not exist" airrr Linux - Networking 2 08-06-2003 02:47 PM
postgreSQL problem: Relation "pg_user" does not exist Noerr Linux - Software 10 06-03-2002 11:01 AM

All times are GMT -5. The time now is 11:51 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration