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*******@postg resql.org 8 1653
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*******@postg resql.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*******@postg resql.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*******@postg resql.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*******@postg resql.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 not recognized by setlocale().
| It looks like you need to initdb.
Now I know nl_NL@euro.UTF-8 is an incorrect locale, I fixed that some
|
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 the whole db changed over
in 1 hour.
Since the upgrade I have been getting the following error message
sporadically.
|
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 with permission
to run pgsql:
postmaster successfully started
LOG: database system was shut down at 2003-11-06 10:27:18 MST
LOG: checkpoint record is at 0/80193C
|
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).
Since then, I found lots of the following in the postmaster output:
2003-11-29 15:19:54 ERROR: large object 4838779 does not exist
2003-11-29 15:20:11 ERROR: large object 4838779 does not exist
|
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 know what's going on but still found nothing.
I do not know when and where the statements are produced that
lead to the error messages. It seems they were generated by
postgres internally but I cannot see when and why. How can
| |
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 observations I've
recently made.
The core of the problem is that Postgres is filling up my hard drive
with swap files at the rate of around 3 to 7 GB per week (that's
Gigabytes not Megabytes) . At this rate it takes roughly two months to
fill up my 40...
|
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 works for files larger
than 8000 Bytes. If a file is less than 1000 Bytes I get the following
message:
Error message:
--invalid input syntax for type oid: "\074\077......";
|
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 can't to erase : postgresql-libs-7xxxx.rpm
bcause there are one package need this lib : perl-DBD-xxxxx.
what can i do ? erase this package (red: perl-DBD-xxxx) or what ?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |