Re: connection dropped from the backend server

On 03/27/2018 07:21 PM, armand pirvu wrote: On Mar 27, 2018, at 6:49 PM, Tom Lane > wrote: Adrian Klaver > writes: On 03/27/2018 04:07 PM, armand pirvu wrote: As long as the connection stays up yes data gets fine across In pg_stat_

Re: connection dropped from the backend server

Sent from my iPhone > On Mar 27, 2018, at 9:21 PM, armand pirvu wrote: > > >>> On Mar 27, 2018, at 6:49 PM, Tom Lane wrote: >>> >>> Adrian Klaver writes: On 03/27/2018 04:07 PM, armand pirvu wrote: As long as the connection stays up yes data gets fine across In pg_stat_activ

Re: connection dropped from the backend server

> On Mar 27, 2018, at 6:49 PM, Tom Lane wrote: > > Adrian Klaver writes: >> On 03/27/2018 04:07 PM, armand pirvu wrote: >>> 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 > >> So what doe

Re: connection dropped from the backend server

Adrian Klaver writes: > On 03/27/2018 04:07 PM, armand pirvu wrote: >> 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 > So what does the rest of that record show? In particular for: I wonder

Re: connection dropped from the backend server

On 03/27/2018 04:07 PM, armand pirvu wrote: 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 So what does the rest of that record show? In particular for: state query backend_start and any others

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 wrote: > >> On 03/27/2018 03:36 PM, armand pirvu wrote: >> Hi all >> I have a pro

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 $SHEL

connection dropped from the backend server

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 <