"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. There are hundreds if not thousands of known bugs in 7.0 that are fixed in more modern versions. Some of them *will* destroy your data. As for getting out of the immediate problem, it looks like there is something wrong with the directory that PG wants to put its socket file into. Perhaps /tmp is not there or not world writable? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend