"Phoenix Kiula" <phoenix.kiula@xxxxxxxxx> writes: > This is the dump command being used on a 8.2.3 database on Linux: > $ pg_dumpall > mydb.sql > $ umask 077 > $ gzip mydb.sql > Then I download the mydb.sql.gz file into my local computer (Mac OSX > with 8.3.3) and unzip it to mydb.sql. That's all fine ... > The local database is already created, with all tables and constraints and all. ... but this isn't. A pg_dump script expects to restore into an empty database. For pg_dumpall, you shouldn't even have created the databases, just start from a virgin installation. regards, tom lane
