Re: DBI/DBD::Pg and transactions

Поиск
Список
Период
Сортировка
От Björn Lundin
Тема Re: DBI/DBD::Pg and transactions
Дата
Msg-id 200707191046.41611.b.f.lundin@gmail.com
обсуждение исходный текст
Ответ на Re: DBI/DBD::Pg and transactions  ("Roderick A. Anderson" <raanders@acm.org>)
Список 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 по дате отправления:

Предыдущее
От: "Pat Maddox"
Дата:
Сообщение: Trying to tune postgres, how is this config?
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: [PERFORM] Parrallel query execution for UNION ALL Queries