X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6D5CA3A3BE3 for ; Mon, 8 Nov 2004 09:36:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96879-06 for ; Mon, 8 Nov 2004 09:36:17 +0000 (GMT) Received: from mail.webline.dk (unknown [83.133.64.48]) by svr1.postgresql.org (Postfix) with ESMTP id 244EE3A3BAC for ; Mon, 8 Nov 2004 09:36:17 +0000 (GMT) Received: from ranger.kakidata.dk (213.237.10.83.adsl.kh.tiscali.dk [::ffff:213.237.10.83]) (AUTH: LOGIN kar@kakidata.dk, TLS: TLSv1/SSLv3,128bits,RC4-MD5) by mail.webline.dk with esmtp; Mon, 08 Nov 2004 10:38:13 +0100 id 001A689B.418F3E86.00002631 From: Kaare Rasmussen Reply-To: kar@kakidata.dk To: pgsql-sql@postgresql.org Subject: Re: Scheduling Jobs In PostgreSQL Date: Mon, 8 Nov 2004 10:36:52 +0100 User-Agent: KMail/1.7.1 References: <20041105170524.11447.qmail@web12002.mail.yahoo.com> In-Reply-To: <20041105170524.11447.qmail@web12002.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200411081036.53654.kar@kakidata.dk> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/72 X-Sequence-Number: 19391 > Is it possbile to schedule jobs in postgres? I believe that the correct answer would be: Yes, it is possible, but No you wouldn't want to do that. A scheduler for PostgreSQL colud be written in Perl, but a much better idea would to use cron or another external scheduler. -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Nordre Fasanvej 12 Åben 12.00-18.00 Email: kar@kakidata.dk 2000 Frederiksberg Lørdag 12.00-16.00 Web: www.suse.dk