connection dropped from the backend server - Mailing list pgsql-general

From armand pirvu
Subject connection dropped from the backend server
Date
Msg-id 88B8EEC2-917D-498D-938B-DD4C2C3C7008@gmail.com
Whole thread Raw
Responses Re: connection dropped from the backend server  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi all


I have a process of some data manipulation and ultimate transfer to a postgres database
A DML statement gest concoted with the transformed data and pusshed into a named pipe
The named pipe is tailed -f in the background like this

nohup $SHELL <<EOF &
tail -f /u1/sys_admin/dba/mypipe.fifo | psql -U csidba -d repdb -h rephost
EOF

All good BUT I do notice every say 10 min although I see the tail and psql processes in the ps output, looking in
pg_stat_activitythere is really nothing the host I run the nohuped tail 


Any suggestions how to approach this/make it better/monitor ?

Thanks
-- Armand



pgsql-general by date:

Previous
From: armand pirvu
Date:
Subject: Re: ERROR: invalid byte sequence for encoding "UTF8": 0xfc
Next
From: Blair Boadway
Date:
Subject: Re: Troubleshooting a segfault and instance crash