Re: Database viewpoint of subject - Sending e-mails from database table with Cronjob

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: A B <gentosaker(at)gmail(dot)com>
Cc: Andre Lopes <lopes80andre(at)gmail(dot)com>, postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database viewpoint of subject - Sending e-mails from database table with Cronjob
Date: 2010-04-21 15:49:12
Message-ID: 20100421114912.c9cbad53.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to A B <gentosaker(at)gmail(dot)com>:

> > [quote]
> > The other way is to let the cron job spawn new processes (up to a
> > limited number of child proceses) as long as there are mails to send.
> > These child processes runs as long as there are mails to send, then
> > they die. The cron job will then mostly do process controll/start new
> > processes.
> > [/quote]
> >
> > How can I do this. I'am thinking to use a PHP Script?
>
> This is getting a little of topic, but I guess something like
> exec('php some_script.php') will work?

There's a php/pgsql list available on this listserve that will get
you a lot more help in this area.

However, I would suggest PHP's pcntl_fork() and friends for creating
multiple processes. Of course, that's only needed if you want to
run them in parallel, which was unclear to me.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andre Lopes 2010-04-21 15:52:59 Re: Database viewpoint of subject - Sending e-mails from database table with Cronjob
Previous Message A B 2010-04-21 15:45:47 Re: Database viewpoint of subject - Sending e-mails from database table with Cronjob