LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-10-2010, 03:41 AM   #1
johnh10000
Member
 
Registered: Nov 2008
Distribution: Ubuntu Lucid Lynx
Posts: 541

Rep: Reputation: 33
postgresql


Hi folks,

my postgres problems have come back to haunt me! Ok I have tried a clean install of the thing, but I still don't get a postgres user.

Code:
http://www.cyberciti.biz/faq/linux-installing-postgresql-database-server/
I have followed the instuctions above, when I get to the
Code:
su - postgres
it asks me for a password, (which I don't know)
I check, and no postgres user. what the heck am i doing wrong?

oh Ubuntu Jaunty
 
Old 01-10-2010, 04:46 AM   #2
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,290

Rep: Reputation: 378Reputation: 378Reputation: 378Reputation: 378
I just tried this on Ubuntu Karmic and their is indeed a postgres user created, however it is not configured with a password. Are you sure it's not being created for you (how are you checking?)? You could set one with:

Code:
sudo passwd postgres
or just become the postgres user via sudo:

Code:
sudo su - postgres
 
Old 01-10-2010, 06:44 AM   #3
johnh10000
Member
 
Registered: Nov 2008
Distribution: Ubuntu Lucid Lynx
Posts: 541

Original Poster
Rep: Reputation: 33
Quote:
Originally Posted by btmiller View Post
I just tried this on Ubuntu Karmic and their is indeed a postgres user created, however it is not configured with a password. Are you sure it's not being created for you (how are you checking?)? You could set one with:

Code:
sudo passwd postgres
or just become the postgres user via sudo:

Code:
sudo su - postgres
opps quite correct, after serveral instals and reinstalls I got that far.

now I did have an /etc/postgres this is now missing, and

[code]
root@tux:~# su - postgres
postgres@tux:~$ createdb mytestdb
createdb: could not connect to database postgres: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
postgres@tux:~$
[/quote]
 
Old 01-10-2010, 11:14 AM   #4
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,290

Rep: Reputation: 378Reputation: 378Reputation: 378Reputation: 378
Did you remember to actually start the postgresql server. On my Karmic version I need to do:

Code:
/etc/init.d/postgresql-8.4 start
as root. To make sure it start automatically on reboot, you can do:

Code:
chkconfig postgresql-8.4 on
Note you'll probably need a slightly different command because you aren't using 8.4, but the idea is the same (startup script in /etc/init.d, use of the chkconfig command). If you're serious about running a server, I highly recommend that you take some time to figure out how to start, stop,m and restart services. There's probably a nice GUI tool for all this somewhere too...
 
  


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
PostgreSql coolrock Slackware 4 10-04-2006 10:24 AM
need help in postgresql yawhum80 Linux - Newbie 0 10-28-2003 10:03 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM
postgreSQL dsgdevil Linux - Software 3 02-20-2003 10:30 PM
PostgreSQL dorian33 Linux - Software 3 01-15-2003 04:01 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 05:33 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