Re: [BUGS] error while starting database

2007-08-18 Thread Douglas Toltzman
All I can tell you, based on this information, Nitin, is that your postmaster is not started, and it is failing to start for some reason. Without any additional information, there is absolutely nothing I can tell you. Try listing the /var/lib/pgsql/data folder. Verify that it does exist

Re: [BUGS] error while starting database

2007-08-18 Thread Tom Lane
"Nitin Saxena" <[EMAIL PROTECTED]> writes: > All the command such asgives following output; > 1: :ls -a/tmp: No such file or directory >2 : "rm -f/tmp/.s.PGSQL.5432" > bash: rm -f/tmp/.s.PGSQL.5432: No such file or directory The reason these commands aren't working for you is

Re: [BUGS] error while starting database

2007-08-18 Thread Gregory Stark
"Douglas Toltzman" <[EMAIL PROTECTED]> writes: > In any case, the server specifically calls out an error creating > "/tmp/.s.PGSQL.5432". I would start by creating a world-writable /tmp > folder. FWIW the correct permissions for /tmp on Unix machines is 1777. It should look like this (note the "t

Re: [BUGS] error while starting database

2007-08-18 Thread Douglas Toltzman
Subject: Re: [BUGS] error while starting database To: Douglas Toltzman <[EMAIL PROTECTED]>, pgsql- [EMAIL PROTECTED] Hi All the command such asgives following output; 1: :ls -a/tmp: No such file or directory 2 : "rm -f/tmp/.s.PGSQL.5432" bash: rm -f/tmp/.s.PGSQ

Re: [BUGS] error while starting database

2007-08-18 Thread Nitin Saxena
Hi All the command such asgives following output; 1: :ls -a/tmp: No such file or directory 2 : "rm -f/tmp/.s.PGSQL.5432" bash: rm -f/tmp/.s.PGSQL.5432: No such file or directory 3:"ps -ax|grep postgres" bash: ps -ax|grep postgres: command not found Does PID in postmast

Fwd: [BUGS] error while starting database

2007-08-18 Thread Nitin Saxena
-- Forwarded message -- From: Nitin Saxena <[EMAIL PROTECTED]> Date: Aug 18, 2007 8:42 AM Subject: Re: [BUGS] error while starting database To: Douglas Toltzman <[EMAIL PROTECTED]>, pgsql-bugs@postgresql.org Hi All the command such asgives following output; 1: :l

Re: [BUGS] error while starting database

2007-08-17 Thread Douglas Toltzman
If it is true that listing /tmp (ls -a /tmp) returns no such file or directory, then that may be the problem. You should have a world- writable /tmp folder, as Tom already pointed out. Also, an update to a more stable version of PostgreSQL is still highly recommended. On Aug 17, 2007, at 1

Re: [BUGS] error while starting database

2007-08-17 Thread Tom Lane
"Nitin Saxena" <[EMAIL PROTECTED]> writes: > I am using postgres 7.0 on linux platform. Egad. At first I thought that was a typo, but if psql really spelled its error message just like that, it must indeed be 7.0 or older :-(. Do yourself a favor and get onto a newer version, NOW. Not tomorrow.

Re: [BUGS] error while starting database

2007-08-17 Thread Douglas Toltzman
PostgreSQL version 7.0 is really, really out of date, but as far as I know, it should still work. I generally use "ps -ax | grep postges" to see if there is a postgres process running. Also, I use "netstat -a" to see open sockets and listening servers. Have you removed the socket file in

[BUGS] error while starting database

2007-08-17 Thread Nitin Saxena
I am using postgres 7.0 on linux platform. My java application was running fine ,but i got this message Connection refused. Check that the hostname and port is correct, and that the postmaster is r unning with the -i flag, which enables TCP/IP networking. at org.postgresql.Connection.openConnectio