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
821 unix 2 [ ] DGRAM785 unix 2 [ ] STREAM CONNECTED 525 Please help as it is urgent. Regards: Nitin Saxena 91-985709 -- Forwarded message -- From: Nitin Saxena <[EMAIL PROTECTED]> Date: Aug 18, 2007 8:42 AM

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

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