From: Ray Stell <stellr@cns.vt.edu>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: Andrew Edson <cheighlund@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Upgrade/Installation problem: Version 7.4.9 to version
Date: Wed, 17 Jan 2007 16:27:51 -0500
Message-ID: <20070117212751.GB16479@cns.vt.edu> (raw)
In-Reply-To: <Pine.LNX.4.64.0701171313440.31602@discord.home.frostconsultingllc.com>
References: <Pine.LNX.4.64.0701171054550.14094@discord.home.frostconsultingllc.com>
<20070117204155.41670.qmail@web34210.mail.mud.yahoo.com>
<20070117211225.GA16479@cns.vt.edu>
<Pine.LNX.4.64.0701171313440.31602@discord.home.frostconsultingllc.com>
On Wed, Jan 17, 2007 at 01:18:06PM -0800, Jeff Frost wrote:
> On Wed, 17 Jan 2007, Ray Stell wrote:
> >Why is there pg_dumpall instead of a pg_dump with some flag?
>
> pg_dumpall does all DBs plus the globals, but I'll have to let one of the
> developers answer why there isn't just a flag for pg_dump.
Thanks.
If I've done a pg_dumpall does some of the sql that gets included
fail in the restore because the objects already exist via the documented
initdb? That is how it works with oracle, you export, install a db, then
import, but the import throws errors because of the installe objects already
exist.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: stellr@cns.vt.edu, jeff@frostconsultingllc.com, cheighlund@yahoo.com
Subject: Re: Upgrade/Installation problem: Version 7.4.9 to version
In-Reply-To: <20070117212751.GB16479@cns.vt.edu>
References: <Pine.LNX.4.64.0701171054550.14094@discord.home.frostconsultingllc.com> <20070117204155.41670.qmail@web34210.mail.mud.yahoo.com> <20070117211225.GA16479@cns.vt.edu> <Pine.LNX.4.64.0701171313440.31602@discord.home.frostconsultingllc.com> <20070117212751.GB16479@cns.vt.edu>
* 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