On Mon, 8 Aug 2005, Buorn, Yoway wrote:
Unfortunately, I don't have the dump and restore in my buffer, but I ran "pg_dumpall > backup.dump" and then I tried to upgrade Gforge and I got errors, so I freaked out and decided to restore before trying again. I then ran "pg_restore -c backup.dump" and it told me the file wasn't an archive so it wouldn't restore.
There's your problem (or at least one of them). The pg_dumpall outputs straight SQL to stdout to recreate all DBs. To restore this, you would just do the following:
psql template1 < backup.dump pg_restore is looking for one of the other output formats (tar or custom). -- Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
