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.kla...@aklaver.com
