Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id DE6166330F8 for ; Fri, 23 Apr 2010 06:10:09 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 09447-04 for ; Fri, 23 Apr 2010 09:09:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f228.google.com (mail-bw0-f228.google.com [209.85.218.228]) by mail.postgresql.org (Postfix) with ESMTP id F1EA563269D for ; Fri, 23 Apr 2010 06:09:58 -0300 (ADT) Received: by bwz28 with SMTP id 28so9913637bwz.34 for ; Fri, 23 Apr 2010 02:09:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:received:message-id :subject:from:to:content-type; bh=f/utsdHs/OOwjzKzn874aUKyGBdfmKSAI0GV5jv4ZA8=; b=RkD3SgWiuMiMXzTsQueAiUKK/x5c5ufE2/Rskfz5YVKvZbMd+NN0WUtv/3c8tDbrXK XSfiJH0BiutfFmeo/0lApJgIGN0/6qSVkFoZtc+q8V56XV+tHj8zaJ8voPbwUfslq7eN 5SJHdrYP4xUjqaimir3n7iEXMwZ+kA+aRicu8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=I+PgT50rwclqciwRlGVSzO0FuKNk4ZgA05snzHPFTFy+m45UDaS9YMZlgp35+lK0vL 718goZNoZy/Q1BMvMHQ1YSqTknEvfTINbZyNJEgnI5/B6NE6vvgO1OXTVLepr3YpMWDO 9AIFeqYxrWMvvyK6rQCm7O7HgUgAs0R1at8V8= MIME-Version: 1.0 Received: by 10.239.131.208 with HTTP; Fri, 23 Apr 2010 02:09:57 -0700 (PDT) Date: Fri, 23 Apr 2010 10:09:57 +0100 Received: by 10.239.167.210 with SMTP id h18mr1005552hbe.97.1272013797309; Fri, 23 Apr 2010 02:09:57 -0700 (PDT) Message-ID: Subject: pcntl_fork() and database concurrency From: Andre Lopes To: pgsql-php@postgresql.org Content-Type: multipart/alternative; boundary=001485f2717089bd8d0484e3ca65 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.835 tagged_above=-10 required=5 tests=AWL=0.064, BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201004/1 X-Sequence-Number: 4130 --001485f2717089bd8d0484e3ca65 Content-Type: text/plain; charset=ISO-8859-1 Hi, I need to write a PHP Script to use with a Crontab. That Crontab will run every 10 minutes. I should use pcntl_fork() to prevent concurrency in database queries, but I don't have sure how to use this PHP function. The reason for use this function is to prevent that if the Crontab don't do the Job in 10 minutes, the next Cronjob will not concur with the job in the background that is running. My question. There are PostgreSQL examples on how to use this function to prevent database concurrency? Best Regards, --001485f2717089bd8d0484e3ca65 Content-Type: text/html; charset=ISO-8859-1 Hi,

I need to write a PHP Script to use with a Crontab. That Crontab will run every 10 minutes.

I should use pcntl_fork() to prevent concurrency in database queries, but I don't have sure how to use this PHP function.

The reason for use this function is to prevent that if the Crontab don't do the Job in 10 minutes, the next Cronjob will not concur with the job in the background that is running.

My question. There are PostgreSQL examples on how to use this function to prevent database concurrency?

Best Regards, --001485f2717089bd8d0484e3ca65--