"Satya Prakash Tripathi" <sptripathi78@yahoo.com> writes:
> postgres server crashes on running "select count(*) from table;" from psql
> client
I don't think so ;-). Perhaps you have a corrupted copy of the postgres
executables?
> test_db=# select count(*) from test_tbl;
> WARNING: terminating connection because of crash of another server process
It's worth noting that this is NOT what you'd see if the select count(*)
itself were failing. Perhaps you have something going on in the
background that is causing a crash of a different query? Look in your
postmaster log to find out what's actually failing, because the above is
merely blowback.
regards, tom lane