LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Password
Debian This forum is for the discussion of Debian Linux.

Notices


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

Rep: Reputation: 0
PostgreSQL 7.3.4 not starting


Hi,

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

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:

Message:
could not connect to server:_Connection refused (0x0000274D/10061)
Is the server running on host "192.168.1.75" 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 2.6.8.1-tt.

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/postmaster.pid
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 postmaster.pid 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,

Regards.

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

Rep: Reputation: 5865Reputation: 5865Reputation: 5865Reputation: 5865Reputation: 5865Reputation: 5865Reputation: 5865Reputation: 5865Reputation: 5865Reputation: 5865Reputation: 5865
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

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian

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