Re: connection dropped from the backend server

As long as the connection stays up yes data gets fine across
In pg_stat_activity I see the node ip address where tail -f piped into psql happens

Sent from my iPhone

> On Mar 27, 2018, at 6:03 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>> 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