Postgres Pro
Downloads
Home   >   mailing lists

Thread: Activate a function on the PostgreSQL server

Activate a function on the PostgreSQL server

From
"Johan Cloete"
Date:
Hi,
I need to Activate a function on the PostgreSQL server automatically at a certain time of each day, how do I do that?
Help much appreciated
Johan Cloete

Re: Activate a function on the PostgreSQL server

From
"Shoaib Mir"
Date:
You can try pgjobs (http://gborg.postgresql.org/project/pgjobs/projdisplay.php) for that purpose.

Thanks,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 10/2/06, Johan Cloete <hjcloete@gmail.com > wrote:
Hi,
I need to Activate a function on the PostgreSQL server automatically at a certain time of each day, how do I do that?
Help much appreciated
Johan Cloete




Re: Activate a function on the PostgreSQL server

From
"A. Kretschmer"
Date:
am  Sun, dem 01.10.2006, um 22:13:29 +0200 mailte Johan Cloete folgendes:
> Hi,
> I need to Activate a function on the PostgreSQL server automatically at a
> certain time of each day, how do I do that?

You can use the CRONTAB. I suppose, you are a UN*X-User.


HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: Activate a function on the PostgreSQL server

From
"A. Kretschmer"
Date:
am  Mon, dem 02.10.2006, um  6:31:06 +0200 mailte Johan Cloete folgendes:
> Hi Andreas,
> Unfortunately I use Windows XP Pro, what are my options ?
> Thanks for your assistance
> Johan Cloete

I'm not familiar with the windows-os, but i know, there are some
toolkits, you should search with google for it.

Please, no silly top-posting with fullquote below.


HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: Activate a function on the PostgreSQL server

From
"Shoaib Mir"
Date:
You can try building the binaries on Windows using MinGW

On 10/2/06, A. Kretschmer <andreas.kretschmer@schollglas.com > wrote:
am  Mon, dem 02.10.2006, um  6:31:06 +0200 mailte Johan Cloete folgendes:
> Hi Andreas,
> Unfortunately I use Windows XP Pro, what are my options ?
> Thanks for your assistance
> Johan Cloete

I'm not familiar with the windows-os, but i know, there are some
toolkits, you should search with google for it.

Please, no silly top-posting with fullquote below.


HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org



--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

Re: Activate a function on the PostgreSQL server

From
"Brandon Aiken"
Date:

For WinXP, call psql with the appropriate settings using Task Scheduler.

 

--

Brandon Aiken

CS/IT Systems Engineer

From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Johan Cloete
Sent: Sunday, October 01, 2006 4:13 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Activate a function on the PostgreSQL server

 

Hi,

I need to Activate a function on the PostgreSQL server automatically at a certain time of each day, how do I do that?

Help much appreciated
Johan Cloete