Knowledge Base : Hard Hat Hosting

Main / Browse Categories / PostgreSQL / How can I reload PostgreSQL thru a cron job?

How can I reload PostgreSQL thru a cron job?

Create a bash script here:

/usr/local/pgsql/restart_db.sh

chmod the file with 755 permissions

chmod 755 /usr/local/pgsql/restart_db.sh

Add this code to the file:

#!/bin/sh
/etc/rc.d/init.d/pg_ctl restart
exit 0

Here is a sample cron entry that would do the job:

45 0 * * * /usr/local/pgsql/restart_db.sh >> /dev/null 2>&1

If you are not familiar with how cron works inside your VDS, please refer to this article:
http://help.hardhathosting.com/question.php/55

User Comments

How can I reload PostgreSQL thru a cron job?

There are no user comments for this topic.

Attachments

No attachments.

Why Choose Our Hosting?

Unmatched Customer Support!
Virtual Private Server technology provides a rich, dedicated-like environment for every account.
We are known for our superb quality, performance and flexible hosting environment. We manage the server, software, and network you do the rest.