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 <[EMAIL PROTECTED]> 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 (firstname.lastname@example.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers