Re: DBI/DBD::Pg and transactions - Mailing list pgsql-general

From Björn Lundin
Subject Re: DBI/DBD::Pg and transactions
Date
Msg-id 200707191046.41611.b.f.lundin@gmail.com
Whole thread Raw
In response to Re: DBI/DBD::Pg and transactions  ("Roderick A. Anderson" <raanders@acm.org>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Pat Maddox"
Date:
Subject: Trying to tune postgres, how is this config?
Next
From: Dimitri Fontaine
Date:
Subject: Re: [PERFORM] Parrallel query execution for UNION ALL Queries