Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Debian This forum is for the discussion of Debian Linux.


Closed Thread
  Search this Thread
Old 03-21-2009, 10:45 PM   #1
LQ Newbie
Registered: Mar 2009
Posts: 3

Rep: Reputation: 0
PostgreSQL 7.3.4 not starting


I have a scenario for linux webserver having PostgreSQL v7.3.4 database and hosting one website on

The website is a type of employee time database management system. The credentials for authorized access are stored in PostgreSQL database.

The website is running and accepting requests on the login page only but the time I try to submit login information, it says fatal error.

I used ISQL for PostgreSQL query analyzer and couple of other query analyzers as well for PostgreSQL database, but the message that returns while connecting on default port i.e. 5432 is as follows:

could not connect to server:_Connection refused (0x0000274D/10061)
Is the server running on host "" and accepting TCP/IP connections on port 5432?.

The admin page for this website is showing the following error:

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"?

What I believe that the website part is running healthy as it is accepting connections and sending pages back to the requesters but the socks part which connects the website to PostgreSQL is turned off accidentally or somewhat.

Is there any way to know whether server is accepting socks connections on 5432 and in working state or in other words can we know that PostgreSQL service is running on it or not?

The kernel for this system is customized, locked and named DEBIAN LILO

I have managed to log into the root and used the following command:

#/etc/init.d/postgresql restart

this command returns the following error message:
pg_ctl: cannot find /var/lib/postgres/data/
Is postmaster running?
Starting PostgreSQL postmaster
Postmaster successfully started

The version which I am using for PostgreSQL is: PostgreSQL 7.3.4

If we copy file to the data directory under PostgreSQL folder, will it help?

Kindly support on this issue as I don't have much knowledge on linux commands as well as it's kernel.

Thank you very much,


Last edited by anon005; 03-21-2009 at 11:09 PM.
Old 03-21-2009, 10:55 PM   #2
Registered: Aug 2002
Posts: 24,384

Rep: Reputation: 5469Reputation: 5469Reputation: 5469Reputation: 5469Reputation: 5469Reputation: 5469Reputation: 5469Reputation: 5469Reputation: 5469Reputation: 5469Reputation: 5469
Please post your thread in only one forum. Posting a single thread in the most relevant forum will make it easier for members to help you and will keep the discussion in one place. This thread is being closed because it is a duplicate.

Closed Thread

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
starting postgresql failed ukrainet Linux - Newbie 3 01-09-2011 11:57 AM
Starting postgresql service: [FAILED] HeyAZ Fedora 1 08-21-2006 09:30 PM
Won't Boot - Starting Printer Service - Starting CUPS jeansond Linux - Newbie 0 10-11-2004 06:39 PM
postgresql starting problem, conf file doesn't exist feetyouwell Linux - Software 0 05-25-2004 10:38 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM > Forums > Linux Forums > Linux - Distributions > Debian

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