Search Postgresql Archives

Re: DBI/DBD::Pg and transactions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thursday 19 July 2007 00:03:19 Roderick A. Anderson wrote:


> I'll post my solution ... when I figure one out!

You could, in the script from cron:
1 - check for the presence of rows in a 'alive_scripts_table'
if any , then exit, and go for the next run, 
alternativly, check that pid in 'ps -ef' so there actually is a script running
2 - create a record in a table, ie insert your pid into a alive_script_table,
3- do your thing
4 - delete your row from the alive_script_table

or use above with a file instead

or just check with ps/tasklist/wmic




-- 
/Björn



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux