Re: upgrade postgres 7.1 to 7.4.2

From: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>
To: csysi <csysi(at)fe(dot)up(dot)pt>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: upgrade postgres 7.1 to 7.4.2
Date: 2004-04-20 21:19:39
Message-ID: 1082495979.408593eb67a4a@webmail.vcsn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Quoting csysi <csysi(at)fe(dot)up(dot)pt>:

> Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that
> the databases are incompatible.
>
> Can i convert the databases ?
>
>
> Thank´s for the help
>
>
> Jorge
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

If you could post the exact error that you are getting and how you are
proceeding that would be helpful.

However, I've upgraded 7.1.3 to 7.4 and I had lots of problems until I used the
pg_dumpall from 7.4. In my case, it had two boxes so I ran the pg_dump from the
7.4 box to the 7.1.3.

Basically, you are dumping over the network. Its very straight forward. All
you have to do is set up the appropriate parameters in the pg_hba.conf file of
your 7.1 box and follow the directions in the man page of pg_dumpall (see the
"-h" parameter).

If you are not on a network, you could install 7.4 version in a different
directory and configure to run on a different port. You still dump via IP this
way. You can run both systems head to head that way and see how things went.

Good luck-

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gralewski Daniel 2004-04-20 21:32:07 tsearch2 and bytea
Previous Message Ivan Sergio Borgonovo 2004-04-20 21:11:46 Re: composite types