Get the code for this tutorial at http://www.rubytreesoftware.com/resou....
Learn how to simply backup and restore a PostgreSQL database using SQL dumps. Learn different techniques and get code and scripts you can use.
I cover pg_dump and pg_dumpall. I show you how to restore using psql or even pg_restore. I also how to detect errors and give practical tips on setting up your basic backup scheme.