LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Ubuntu
User Name
Password
Ubuntu This forum is for the discussion of Ubuntu Linux.

Notices

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

Rep: Reputation: 0
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
 
Old 06-21-2005, 02:57 AM   #2
elsheikhmh
Member
 
Registered: Aug 2004
Location: Cairo, Egypt
Distribution: Slackware
Posts: 101

Rep: Reputation: 15
[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
 
Old 06-21-2005, 10:19 AM   #3
cgetty
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.

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

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

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


Reply


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 07:41 AM
newbie question: whats the difference between "su root", "su" and "su -&quo mojarron Slackware 9 12-07-2009 04:08 PM
psql: FATAL 1: IDENT authentication failed for user "postgres" linuxtesting2 Linux - General 3 06-16-2004 12:48 PM
RH9 NIS login error: "home directory does not exist" airrr Linux - Networking 2 08-06-2003 01:47 PM
postgreSQL problem: Relation "pg_user" does not exist Noerr Linux - Software 10 06-03-2002 10:01 AM


All times are GMT -5. The time now is 09:44 PM.

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