pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump from 8.4 to 8.3
2+ messages / 2 participants
[nested] [flat]
* pg_dump from 8.4 to 8.3
@ 2011-11-07 16:54 Kieren Scott <kierenscott@hotmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Kieren Scott @ 2011-11-07 16:54 UTC (permalink / raw)
To: pgsql-admin
Hi,
I need to migrate some data (a few GB's) from an 8.4 database to an 8.3 database using pg_dump. What is the best way to acheive this?
E.g. Run pg_dump from the 8.3 host pointing it at the 8.4 host and include the version mismatch parameter?
Or, run pg_dump on the 8.4 host, then zip the 8.4 dump file, transfer it to the 8.3 host and run pg_restore from the 8.3 host - will I encounter version problems doing this?
Or any other methods that would be better suited?
TIA
=
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dump from 8.4 to 8.3
@ 2011-11-07 17:16 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Kieren Scott <kierenscott@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2011-11-07 17:16 UTC (permalink / raw)
To: Kieren Scott <kierenscott@hotmail.com>; pgsql-admin
Kieren Scott <kierenscott@hotmail.com> wrote:
> I need to migrate some data (a few GB's) from an 8.4 database to
> an 8.3 database using pg_dump. What is the best way to acheive
> this?
This is always a little tricky because you may have objects in your
later-release database which can't be represented in the older
release. My inclination would be to dump with the later release and
hand-modify the file for each error you run into, until you get a
clean restore. Be sure you have an editor which doesn't need to
load the whole file into RAM at one time, if the database is large.
Of course, an even easier route is generally to avoid moving
backward.
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-11-07 17:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-11-07 16:54 pg_dump from 8.4 to 8.3 Kieren Scott <kierenscott@hotmail.com>
2011-11-07 17:16 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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