There are lots of great backup tools and utilities out there, but utilizing a simple script and cron task to target specific PostgreSQL database is often the fastest way to a locally based backup procedure. The below shell script is run as the postgres user on a Linux version 2.6.9-42.0.3.ELsmp (Red Hat 3.4.6-3) with PostgreSQL [...]
Archive for the ‘Bash’ Category
Automatic cron backup of PostgreSQL database
Posted in Bash, Postgres, tagged backup, cron, pgsql, pg_dump, PostgreSQL, shell script on June 3, 2011 | Leave a Comment »
