Re: connection dropped from the backend server

On 03/27/2018 03:36 PM, armand pirvu wrote:
> 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

Could it be that pg_stat_activity shows nothing because the DML has
completed when you look?

Does the data find its way into the database?

>
>
> Any suggestions how to approach this/make it better/monitor ?
>
> Thanks
> -- Armand
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com