Latest LQ Deal: Latest LQ Deals
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 11-06-2007, 12:51 AM   #1
LQ Newbie
Registered: Jan 2006
Posts: 1

Rep: Reputation: 0
cannot open `/var/lib/pgsql/data/ 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/' for reading: No such file or directory

Please guide me to resolve this problem

Thanks & Regards,
Ashish Zankar,
Motorola India

Last edited by ashishzankar; 11-06-2007 at 05:20 AM. Reason: incorrect entry
Old 11-07-2007, 10:22 AM   #2
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).

no file
no postgresql connectivity

Try starting the postmaster server first:
postmaster -D /usr/local/pgsql/data
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
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

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



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 > Forums > Linux Forums > Linux - Newbie

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

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