LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-15-2009, 11:11 AM   #1
mrotsliah
LQ Newbie
 
Registered: May 2009
Posts: 25

Rep: Reputation: 15
Problems with PostgreSQL 8.3 on Ubuntu Server 8.04.


I have never worked with database stuff. I need to set up a database for Moodle. I know I have PostgreSQL 8.3 installed on my computer. I try to create a new database, and it responds

createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "bob"

or

createdb: could not connect to database postgres: FATAL: the database system is shutting down

I try to create a new user by typing

sudo -u postgres createuser -D -A -P myuser

and it responds

createuser: could not connect to database postgres: FATAL: the database system is shutting down


I don't know what I am doing wrong. My copy of PostgreSQL must not like me.

I would appreciate any help. Thank you.
 
Old 08-16-2009, 09:09 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917Reputation: 917
What happens is you 'sudo su - postgres'
and run psql (assuming that postgres is still running; if it isn't,
restart it using [as root, or using sudo] '/etc/init.d/postgresql-8.3 start')?


Do you see anything in postgres' log (not sure where it lives in debian/
ubuntu) pertaining to the crash?


Chances are also that Ubunut doesn't create any database by default (and
postgres' default is to connect to a database going by the same name as
the user when invoked). Try a 'createdb' as the postgres user to begin with.






Cheers,
Tink
 
  


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
Problems setting up a NTP Server on Ubuntu Server 9.04 mikesmith20001 Linux - Server 1 08-10-2009 10:14 AM
Postgresql Setting Problems in ubuntu 5.04 luisben Ubuntu 1 05-09-2008 03:18 AM
LXer: Database Server With postgresql and pgadmin3 in Ubuntu LXer Syndicated Linux News 0 04-20-2008 01:50 PM
Postgresql, JDBC on Ubuntu Kateto Linux - Server 0 09-06-2006 01:22 PM
pljava on postgresql in ubuntu pelgrimforever Ubuntu 0 06-05-2006 12:04 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:49 PM.

Main Menu
Advertisement
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
Open Source Consulting | Domain Registration