|save_db||The main backup directory|
|dbProd||The secondary backup directory|
|DATE||The date of the backup in the specified format|
|dbprod||The name of the database to be saved|
|/opt/postgres/9.0/bin/pg_dump||The path to the pg_dump binary|
|-h||Specifies the host name of the machine on which the server is running, Example : localhost|
|-p||Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections, Example 5432|
|-U||User name to connect as.|
To avoid cluttering the backup tool because the backup of old files is supposed to be done.
To enable this feature please uncomment line N° 3.
rm -R / save_db / *
The following command is used to edit the cron table for the current user.
Schedule the launch of the script with the calendar at 11pm.
0 23 * * * /saveProdDb.sh