You could also look into upgrading via pg_upgrade, if you don't want
to go through the dump/restore cycle. Even in that case if you can do
a test of pg_dump (one for schema, one for data) and make sure it
loads into the new db without any issues. 8.3 -> 9.0 is pretty
harmless (you might want to thi
I've performed a very similar upgrade including postgis upgrade at the same
time, we used the following command examples ... also put some simple scripting
together to dump multiple databases in parallel as downtime was critical:
Dump database data: pg_dump -Fc database --compress=1 > /mnt/dumps
