| From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
|---|---|
| To: | David Blewett <david(at)dawninglight(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: migrate data 6.5.3 -> 8.3.1 |
| Date: | 2008-08-14 14:51:16 |
| Message-ID: | 20080814145116.GA4402@it.is.rice.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
When upgrading, you use the pg_dump from the new version to
dump the old database. Then it can take care of incidental
changes during the process. I think that the mailing list
archives have articles on upgrading from v6.5. I do not think
that you can go straight from v6.5 to v8.3. You will almost
certainly need to use v7.2-7.4 as a intermediate step, maybe
v8.0 will work, check the list archives. Good luck.
Cheers,
Ken
On Thu, Aug 14, 2008 at 10:34:11AM -0400, David Blewett wrote:
> On Thu, Aug 14, 2008 at 9:58 AM, alexander lunyov <lan(at)zato(dot)ru> wrote:
> > Hello everybody.
> >
> > We have a dusty old server, FreeBSD 3.3-RELEASE, PostgreSQL 6.5.3.
> > I need to migrate four DBs from old server to new server (FreeBSD 6.2,
> > PostgreSQL 8.3.1).
>
> Just an FYI: I advised Alexander to post here, because I thought some
> of the devs might have older pg installs/dump tools and might be able
> to give some advice.
>
> David Blewett
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zdenek Kotala | 2008-08-14 15:29:28 | Re: Patch: propose to include 3 new functions into intarray and intagg |
| Previous Message | David Blewett | 2008-08-14 14:34:11 | Re: migrate data 6.5.3 -> 8.3.1 |