By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,761 Members | 1,014 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,761 IT Pros & Developers. It's quick & easy.

upgrade postgres 7.1 to 7.4.2

P: n/a
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 ma*******@postgresql.org

Nov 23 '05 #1
Share this Question
Share on Google+
8 Replies

P: n/a
Quoting csysi <cs***@fe.up.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 ma*******@postgresql.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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #2

P: n/a
Quoting csysi <cs***@fe.up.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 ma*******@postgresql.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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #3

P: n/a
On Tue, Apr 20, 2004 at 14:36:57 +0100,
csysi <cs***@fe.up.pt> wrote:
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 ?


You need to do a dump and reload to go between major releases (e.g.
from 7.1.x to 7.2.x). If you overlaid your 7.1 binaries you are going
to have to uninstall 7.4 and reinstall 7.1 and dump the database.
If you have the 7.1 binaries and the 7.4 binaries available, you
should use the 7.4 pg_dump(all) to do the dump as it is better
about handling dependencies and some other things.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #4

P: n/a
On Tue, 20 Apr 2004, csysi wrote:
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 ?


Yes, you need to reinstall 7.1, then use the pg_dump/pg_dumpall from 7.4.2
to dump the data out of the running 7.1 database. If you setup the two
databases on seperate machines this is easier to do, and how I usually
upgrade Postgresql at work.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #5

P: n/a
On Tue, Apr 20, 2004 at 14:36:57 +0100,
csysi <cs***@fe.up.pt> wrote:
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 ?


You need to do a dump and reload to go between major releases (e.g.
from 7.1.x to 7.2.x). If you overlaid your 7.1 binaries you are going
to have to uninstall 7.4 and reinstall 7.1 and dump the database.
If you have the 7.1 binaries and the 7.4 binaries available, you
should use the 7.4 pg_dump(all) to do the dump as it is better
about handling dependencies and some other things.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #6

P: n/a
On Tue, 20 Apr 2004, csysi wrote:
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 ?


Yes, you need to reinstall 7.1, then use the pg_dump/pg_dumpall from 7.4.2
to dump the data out of the running 7.1 database. If you setup the two
databases on seperate machines this is easier to do, and how I usually
upgrade Postgresql at work.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #7

P: n/a
On Tue, 20 Apr 2004, Bruno Wolff III wrote:
On Tue, Apr 20, 2004 at 14:36:57 +0100,
csysi <cs***@fe.up.pt> wrote:
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 ?


You need to do a dump and reload to go between major releases (e.g.
from 7.1.x to 7.2.x). If you overlaid your 7.1 binaries you are going
to have to uninstall 7.4 and reinstall 7.1 and dump the database.
If you have the 7.1 binaries and the 7.4 binaries available, you
should use the 7.4 pg_dump(all) to do the dump as it is better
about handling dependencies and some other things.


Bruno, a ton of work went into making the pg_dump in 7.4 capable of
dumping the older versions back through, I believe 7.0 or 6.5 or so.
Basically, the recommended method now is to just use 7.4's dump of a
running 7.1 database to get the dump.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #8

P: n/a
On Tue, 20 Apr 2004, Bruno Wolff III wrote:
On Tue, Apr 20, 2004 at 14:36:57 +0100,
csysi <cs***@fe.up.pt> wrote:
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 ?


You need to do a dump and reload to go between major releases (e.g.
from 7.1.x to 7.2.x). If you overlaid your 7.1 binaries you are going
to have to uninstall 7.4 and reinstall 7.1 and dump the database.
If you have the 7.1 binaries and the 7.4 binaries available, you
should use the 7.4 pg_dump(all) to do the dump as it is better
about handling dependencies and some other things.


Bruno, a ton of work went into making the pg_dump in 7.4 capable of
dumping the older versions back through, I believe 7.0 or 6.5 or so.
Basically, the recommended method now is to just use 7.4's dump of a
running 7.1 database to get the dump.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.