pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to run a posgresql function/procedure thro crontab in Linux ES 4.0
2+ messages / 2 participants
[nested] [flat]
* How to run a posgresql function/procedure thro crontab in Linux ES 4.0
@ 2005-12-27 11:31 Murugan G <murugan.g@renaissance-it.com>
2005-12-27 14:23 ` Re: How to run a posgresql function/procedure thro crontab Koen Martens <pgsql@metro.cx>
0 siblings, 1 reply; 2+ messages in thread
From: Murugan G @ 2005-12-27 11:31 UTC (permalink / raw)
To: pgsql-admin
Hello,
If anybody tried, please let me know how to run a postgresQL function/procedure thro crontab in Linux ES 4.0
Thanks and regards,
G.Murugan,
Sr. Software Engineer.
Extn. 1658
===========================================================================
Sobha Renaissance Information Technology Private Limited
An SEI-CMM & P-CMM Level 5 Company
World's 1st SSE-CMM Level 5 Company
BS 7799 certified by British Standards Institute
ISO 9001:2000 Certified by TÜV Rheinland/Berlin-Brandenburg
A Six Sigma Practice Company
Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91 80 51252222
Email : murugan.g@renaissance-it.com; Web: www.renaissance-it.com
===========================================================================
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete all copies from any computer.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to run a posgresql function/procedure thro crontab
2005-12-27 11:31 How to run a posgresql function/procedure thro crontab in Linux ES 4.0 Murugan G <murugan.g@renaissance-it.com>
@ 2005-12-27 14:23 ` Koen Martens <pgsql@metro.cx>
0 siblings, 0 replies; 2+ messages in thread
From: Koen Martens @ 2005-12-27 14:23 UTC (permalink / raw)
To: Murugan G <murugan.g@renaissance-it.com>; +Cc: pgsql-admin
Murugan G wrote:
> Hello,
> If anybody tried, please let me know how to run a postgresQL
> function/procedure thro crontab in Linux ES 4.0
>
>
$ psql --help
This is psql 8.1.0, the PostgreSQL interactive terminal.
......
-c COMMAND run only single command (SQL or internal) and exit
......
So just put a proper invocation of psql in cron, eg something like:
0 * * * * /path/to/binary/psql -U foo -h yourhost.com -c "select bar()"
dbname 1> /dev/null
Gr,
Koen
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-12-27 14:23 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-27 11:31 How to run a posgresql function/procedure thro crontab in Linux ES 4.0 Murugan G <murugan.g@renaissance-it.com>
2005-12-27 14:23 ` Re: How to run a posgresql function/procedure thro crontab Koen Martens <pgsql@metro.cx>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox