LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 09-21-2004, 11:35 PM   #1
treotan
Member
 
Registered: Jun 2004
Posts: 126

Rep: Reputation: 15
Question Of Postgresql


Why i typed psql, it would be prompt a msg:

[root@localhost local]# psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


And How do I know it is install properly?


Thks
 
Old 09-22-2004, 12:00 AM   #2
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,275

Rep: Reputation: 370Reputation: 370Reputation: 370Reputation: 370
How did you install it? Did you actually start the postmaster (ps aux will give you a list of everything that's running)?
 
Old 09-22-2004, 12:57 AM   #3
treotan
Member
 
Registered: Jun 2004
Posts: 126

Original Poster
Rep: Reputation: 15
It did not show the service something like pgsql..! so I think it is not running!
But Why it was prompt as following msg when I typed psql?

[root@localhost local]# psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
 
Old 09-22-2004, 01:18 AM   #4
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,275

Rep: Reputation: 370Reputation: 370Reputation: 370Reputation: 370
You have to start the postmaster (the daemon that accepts client connections) before you can connect to the PostgreSQL server. I do this through the pg_ctl utility that is installed in /usr/local/pgsql/bin (it might be somewhere else on your system, depending on how stuff is installed). There's copious documentation about this at the PostgreSQL Web site, which I suggest you read if you're having trouble. I've only tinkered with Postgres, and never used it seriously, so I'm afraid I can't help much more than this.
 
Old 09-22-2004, 05:20 AM   #5
treotan
Member
 
Registered: Jun 2004
Posts: 126

Original Poster
Rep: Reputation: 15
I planned to install again the new version postgresql 7.4.5; What different to install by rpm / tar.gz?
 
Old 09-22-2004, 07:45 AM   #6
michaelk
Moderator
 
Registered: Aug 2002
Posts: 14,931

Rep: Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520
The difference between the RPM and the tar.gz is the RPM is already compiled and configured to run. The tar.gz is the source code which needs to be compiled and configured. As a newbie I would use the RPM and then upgrade once I've become more familar with the server

psql is the command line client and as stated postmaster is the database server. Since the server is a network application it runs by default on port 5432.
 
  


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 postmaster//users question DoubleLetter Linux - General 2 02-05-2008 04:14 PM
Postgresql Easy Question I think init Linux - Software 1 09-16-2004 09:25 AM
PostgreSQL (or just SQL) question jacksmash Programming 6 12-30-2003 11:46 AM
PostgreSQL question digital bots Linux - Newbie 3 06-18-2002 01:37 AM
MySQL of PostgreSQL that is the question? Noerr Linux - Software 17 06-02-2002 04:07 PM


All times are GMT -5. The time now is 04:54 AM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration