From: Tom Lane <tgl@sss.pgh.pa.us>
To: Phoenix Kiula <phoenix.kiula@gmail.com>
Cc: PG-General Mailing List <pgsql-general@postgresql.org>
Subject: Re: Dumping/Restoring with constraints?
Date: Wed, 27 Aug 2008 10:42:56 -0400
Message-ID: <23571.1219848176@sss.pgh.pa.us> (raw)
In-Reply-To: <e373d31e0808270712n7c599a82sca5a6bbf6cc5c20a@mail.gmail.com>
References: <e373d31e0808270619uba31c8eodc2c85662b85140a@mail.gmail.com>
<22708.1219845242@sss.pgh.pa.us>
<e373d31e0808270712n7c599a82sca5a6bbf6cc5c20a@mail.gmail.com>
"Phoenix Kiula" <phoenix.kiula@gmail.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, phoenix.kiula@gmail.com, pgsql-general@postgresql.org
Subject: Re: Dumping/Restoring with constraints?
In-Reply-To: <23571.1219848176@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox