Hi all,

    When I try testlo.c with some modifications, I hit "Ctrl-C" key
sometimes OR program crash abnormally I got messages when I try to
connect a db , see below.  But all other db seems to be working,
in such case is there any way to revive server without "restarting" by
kill -TERM xxx and restart the postmaster?  Because the other db is very
frequently used by other people!  I guess that such problem is
due to the "large object" or locks(I tried to remove pg_vlock, vacuum
..).

    The only way is restarting the postmaster?

C.S.Park

After crashing "testlo.c" with incorrect treatment on a large object

> psql -h xxx testdb
testdb=> \dt
PQexec() -- Request was sent to backend, but backend closed the channel
before responding.
        This probably means the backend terminated abnormally before or
while processing the request.

and I could not see any tables... but usual sql queris was possible! on
testdb such as create table, select...
e.g.
after crashing my program(testlo.c try to connect "testdb")

> psql -h xxx testdb
testdb=> \dt
PQexec() -- Request was sent to backend, but backend closed the channel
before responding.
        This probably means the backend terminated abnormally before or
while processing the request.
testdb=>create table t (i int4);
PQexec() -- There is no connection to the backend.
testdb=>\c testdb    <- reconnect
testdb=>select * from t where int4mul(1,i) > 4;
i
-
(0 rows)
testdb=>\dt
PQexec() -- Request was sent to backend, but backend closed the channel
before responding.
        This probably means the backend terminated abnormally before or
while processing the request.


Fri, 22 May 1998 07:20:30 +0900
"Park, Chul-Su" <pcs@mhlx01.kek.jp>
[QUESTION]  backend closed the channel ... after crash usr prog,
	how can I fix?