Taking regular backups of your data is of prime importance to any system admin or database admin worth their salt. We utilize PostgreSQL for a lot of our business solutions and when it comes to taking periodic and hands free backup of a large group of PostgreSQL databases on our Linux Server the time and effort required was simply too much. So we came up with a solution to make the process of taking database backups in PostgreSQL user interaction free with minimum fuss. The result is the below given Linux Shell script which can automate the process of taking PostgreSQL database backups.

This article presents you with the source code and the usage of the linux shell script which will automate the process of taking dumps or backups with the pg_dump utility on a PostgreSQL Server.