pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How 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>
  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 14:23  Koen Martens <pgsql@metro.cx>
  parent: Murugan G <murugan.g@renaissance-it.com>
  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