| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Chris <dmagick(at)gmail(dot)com> |
| Cc: | Carlos <CarlosO(at)pbsinet(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Converting 7.x to 8.x |
| Date: | 2007-01-25 06:31:44 |
| Message-ID: | 20070125063144.GA3943@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jan 25, 2007 at 15:43:19 +1100,
Chris <dmagick(at)gmail(dot)com> wrote:
> Carlos wrote:
> >What would be the faster way to convert a 7.4.x database into an 8.x
> >database? A dump of the database takes over 20 hours so we want to
> >convert the database without having to do a dump and resptore.
>
> That's your only option as far as I know (I'm sure someone will correct
> me if that's not the case).
>
> You can't do a binary conversion or anything like that because the
> postgres internals are different between major versions.
People use slony to do this. You can ask on the slony list for more
details.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | org | 2007-01-25 09:32:35 | Re: STOP all user access except for admin for a few minutes? |
| Previous Message | Bruno Wolff III | 2007-01-25 06:26:26 | Re: indexing primary and foreign keys w/lookup table |