From: Tom Lane <tgl@sss.pgh.pa.us>
To: Anony Mous <fyngyrz@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: restore failure
Date: Mon, 17 Nov 2008 12:47:05 -0500
Message-ID: <5008.1226944025@sss.pgh.pa.us> (raw)
In-Reply-To: <1561aee60811170655h55a5a777kf6862d2a262ad3f@mail.gmail.com>
References: <1561aee60811170655h55a5a777kf6862d2a262ad3f@mail.gmail.com>
"Anony Mous" <fyngyrz@gmail.com> writes:
> I have a moderate size database under RH9 / pgsql 7.3 (I think... that's the
> PG_VERSION in the postgres user data directory.) Under 100 mb for the whole
> thing.
> I'm trying to move the DB to postgresql 8.3 under the current ubuntu in a
> 4-core, 4gb machine.
Try using the 8.3 pg_dump (or more likely pg_dumpall) to dump from the
7.3 server. (Just point it at that server over the net, you don't need
to install it on the old machine.)
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, fyngyrz@gmail.com
Subject: Re: restore failure
In-Reply-To: <5008.1226944025@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