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 8 1641
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
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
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
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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Sander Smeenk |
last post by:
Hi,
After a very recent postgresql update, the postmaster failed to start
because of this:
| PANIC: The database cluster was initialized with LC_CTYPE
| 'nl_NL@euro.UTF-8', which is...
|
by: Abdul-Wahid Paterson |
last post by:
Hi,
I have had a site working for the last 2 years and have had no problems
until at the weekend I replace my database server with a newer one. The
database migration went like a dream and I had...
|
by: Steve Wampler |
last post by:
I just upgraded a system from RedHat 8.0 to RedHat 9.0,
which also upgrades the version of PostgreSQL.
However, I cannot run pgsql to restore the databases
because I don't know a 'default' user...
|
by: Dirk Försterling |
last post by:
Hi all,
a few days ago, I upgraded from PostgreSQL 7.2.1 to 7.4, following
the instructions in the INSTALL file, including dump and restore.
All this worked fine without any error (message).
...
|
by: Dirk Försterling |
last post by:
Hi,
sorry for reposting, but it seems my message just hit nothing
but air. If I posted to the wrong list or did something else
wrong with the message, please let me know.
I really want to...
|
by: csysi |
last post by:
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
|
by: Joe Lester |
last post by:
This thread was renamed. It used to be: "shared_buffers Question". The
old thread kind of died out. I'm hoping to get some more direction by
rephrasing the problem, along with some extra...
|
by: NM |
last post by:
Hello,
I've got a problem inserting binary objects into the postgres database.
I have binary objects (e.g. images or smth else) of any size which I
want to insert into the database. Funny is it...
|
by: zaky |
last post by:
I have a problem when upgrade to new version Postgres (v8.x.x) on Reh HAT 9.0.
i was uninstall old version (Postgres 7.x.x) package with command
rpm -e postgresqlxxxxx.rpm
but only one package...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |