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

From: Andre Lopes <lopes80andre(at)gmail(dot)com>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: A B <gentosaker(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:52:59
Message-ID: t2i18f98e681004210852z8fcffabeq9d82e82a7f564179@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for the reply.

I will move the topic to the php/pgsql if I don't get how to do it.

Thanks for the help.

Best Regards,

On Wed, Apr 21, 2010 at 4:49 PM, Bill Moran <wmoran(at)potentialtech(dot)com>wrote:

> 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/<http://people.collaborativefusion.com/%7Ewmoran/>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-04-21 16:30:06 Re: WARNING: out of shared memory
Previous Message Bill Moran 2010-04-21 15:49:12 Re: Database viewpoint of subject - Sending e-mails from database table with Cronjob