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 11-06-2007, 12:51 AM   #1
ashishzankar
LQ Newbie
 
Registered: Jan 2006
Posts: 1

Rep: Reputation: 0
cannot open `/var/lib/pgsql/data/postmaster.pid file


[root@ipdr data]# /sbin/service postgresql start
psql: could not connect to server: No such file or directory OK ]
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
head: cannot open `/var/lib/pgsql/data/postmaster.pid' for reading: No such file or directory

Please guide me to resolve this problem

Thanks & Regards,
Ashish Zankar,
sysadmin
Motorola India
bangalore.

Last edited by ashishzankar; 11-06-2007 at 05:20 AM. Reason: incorrect entry
 
Old 11-07-2007, 10:22 AM   #2
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian stable
Posts: 5,908

Rep: Reputation: 356Reputation: 356Reputation: 356Reputation: 356
After reading the postmaster man page, and a few other things on the web, this sounds like a problem with the postmaster server (it isn't running).

Therefore:
no postmaster.pid file
no postgresql connectivity

Try starting the postmaster server first:
Quote:
postmaster -D /usr/local/pgsql/data
or
pg_ctl start -l logfile /usr/local/pgsql/data
substituting the actual path to your /pgsql/data directory.
 
Old 11-07-2007, 12:19 PM   #3
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
Which distribution are you using, how did you install postgres?



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
squid dead but pid file exists chenboly Linux - Networking 3 05-31-2007 03:10 PM
ntpd dead but pid file exists wjn Linux - Networking 15 05-22-2005 01:32 PM
Is there a way to make a program create a pid file? blk96gt Slackware 1 10-29-2004 12:59 PM
/var/run/[XXX].pid - Tcl pid code liguorir Linux - Software 1 05-20-2004 11:32 PM
ERROR: Couldn't write pid to pid file lawrencegoodman Linux - Newbie 2 02-13-2004 09:05 PM

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

All times are GMT -5. The time now is 03:53 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
Open Source Consulting | Domain Registration