Migration using pg_restore

From: "Jan Cruz" <malebug(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Migration using pg_restore
Date: 2006-02-18 07:59:29
Message-ID: 493da2780602172359p3fa963b3xb1b4e8f77e97758@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Note:
Assumption tables are already created and/or in existence.

I dump all data from a 7.3.5 db using LATIN9 encoding.
When I restore it back to a 8.1.3 db using LATIN9 encoding
it is much slower than restoring back to a 7.3.xx db.
Restoration from 7.3.5 to 8.1.3 took more or less 24 hours against
less than an hour from 7.3.5 db to any 7.3.xx db.

I don't have any idea why is it that way...

Anyone?

Browse pgsql-general by date

  From Date Subject
Next Message Jan Cruz 2006-02-18 08:06:23 Re: Converting an ASCII database to an UTF-8 database
Previous Message Rick Gigger 2006-02-18 07:48:53 Re: Converting an ASCII database to an UTF-8 database