Linux webserver & PostgreSQL
Hi,
I have a scenario for linux webserver having PostgreSQL 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 renamed DEBIANA LILO 2.6.8.1-tt. I don't have the root password as well. But in the worst scenario, we can break it for temporarily. 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. |
Quote:
If you can't connect, the DBA is going to have to allow connections, in order for your program/server to connect. If it DOES connect from the command line, your web code is broken, and needs to be fixed. Since you don't give any code examples, or tell us what version of postgres you're using, or what version/distro of Linux, it's hard to give more specific details, other than very basic troubleshooting. |
Linux webserver & PostgreSQL
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 PostgreAQL is: PostgreSQL 7.3.4 I want to ask one thing more that like MS Access stores its database in a .mdb file and sql stores in a .mdf file, what is the extension of a postgresql database file? is it .pdd? and where is it located? Please help... |
Quote:
Check your Postgres configuration, to see where you're saving the files. Check the Postgres documentation for information about the files. |
Quote:
while, and you're 5 versions behind on that! 7.3.9 (the last of the 7.3 series) was released on 31/01/2005 ... Quote:
store its information. You can determine their location by looking at your startup-script. They usually don't have an extension, Postgres comes from a Unix background, extensions mean diddly-squat. Cheers, Tink |
All times are GMT -5. The time now is 11:06 PM. |