connection dropped from the backend server

From: armand pirvu <armand(dot)pirvu(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: connection dropped from the backend server
Date: 2018-03-27 22:36:12
Message-ID: 88B8EEC2-917D-498D-938B-DD4C2C3C7008@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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_activity there is really nothing the host I run the nohuped tail

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

Thanks
-- Armand

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Blair Boadway 2018-03-27 22:47:54 Re: Troubleshooting a segfault and instance crash
Previous Message armand pirvu 2018-03-27 22:30:56 Re: ERROR: invalid byte sequence for encoding "UTF8": 0xfc