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.klaver@xxxxxxxxxxx
