Re: DBI/DBD::Pg and transactions

From: Björn Lundin <b(dot)f(dot)lundin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DBI/DBD::Pg and transactions
Date: 2007-07-19 08:46:41
Message-ID: 200707191046.41611.b.f.lundin@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2007-07-19 10:14:29 Re: [PERFORM] Parrallel query execution for UNION ALL Queries
Previous Message Pat Maddox 2007-07-19 06:51:01 Trying to tune postgres, how is this config?