I was fairly impressed with pgAdmin III when I first used it. It seems to be simple to use for anyone who can’t write their own SQL statements. I wasn’t too good and it and each time I execute a change in the database I have a feeling the world’s going to end. But one thing the pgAdmin III doesn’t do well is backup and restore.
(Using pgAdmin III for PostgreSQL. A screenshot.)
0. Objective
In the end it’s best to use the command prompt (or terminal) and in this really beginner tutorial, we’ll do a backup and restore using the command line.
1. Set PATH for PostgreSQL in Windows Vista
This guide assumes you install in ‘C:\Program Files\PostgreSQL\8.3\’, the default installation directory. (more…)