473,324 Members | 2,313 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Upgrading from 7.3.6 to 7.4.2 pg_dumpall question

Finally getting around to upgrading to 7.4.2 from 7.3.6. I thought I read
somewhere that for this upgrade, it would be advantageous to use pg_dumpall
from the 7.4..x version versus using the version for 7.3.x.. Is that
correct?

TIA
Patrick Hatcher

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #1
1 1163
"Patrick Hatcher" <PH******@macys.com> writes:
Finally getting around to upgrading to 7.4.2 from 7.3.6. I thought I read
somewhere that for this upgrade, it would be advantageous to use pg_dumpall
from the 7.4..x version versus using the version for 7.3.x.. Is that
correct?


In any upgrade (since 7.0, or whenever it was that we started making
pg_dump able to cope with prior versions), it's considered good practice
to use the later pg_dump if you conveniently can. The idea is that this
gets you the benefit of any bug fixes that have appeared in the newer
pg_dump version.

I don't recall at this late hour whether there are any specific bugs
that would make this consideration important for 7.3.6 versus 7.4.2.
But on general principles, I'd recommend doing it that way.

regards, tom lane

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

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

Nov 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: javier garcia - CEBAS | last post by:
Hello; With your help I've got a recently installed postgres7.3.4 version. But when I try to upgrade my data I have an error. I've spent a couple of hour trying to solve it with no result, and...
1
by: Edwin Quijada | last post by:
Hi! I am trying to do a dump all and when I do this I get this error pg_dumpall: query failed: ERROR: Unable to convert abstime 'invalid' to timestamp pg_dumpall: query was: SELECT usename,...
0
by: Hunter Hillegas | last post by:
I am trying to restore a file that I created using pg_dumpall. I have searched the archives and the documentation. I know I am supposed to use pg_restore but there is no example for restoring...
2
by: Piyush Agarwal | last post by:
Hi, I had the version 7.1 of postgresql running fine on Redhat 7.1. Before upgrading my OS to RedHat 9, I forgot saying pgdump_all - is there a way now to read the files stored with version 7.1...
3
by: Patrick Hatcher | last post by:
Did a pg_dumpall from my production database (7.3.2) and I tried to restore to my Dev database (7.4). I receive a data exception error during the import and was stupid enough not to write it down....
2
by: Adam Williams | last post by:
Hi, as my title states I'm trying to upgrade from 7.2 to 7.3 on redhat linux 9. I've been following the documentation instructions on the website but ran into problems. I searched on google but...
1
by: Bob Powell | last post by:
** High Priority ** Hello everyone, I have a restore file created by pg_dumpall. The restore file has two users associated with ownership of tables. The postgres user and a user called...
5
by: NTPT | last post by:
Regardi I recently compile Postgresql 7.4.3 with gcc 3.4.0 on RH 7.3 . Regression tests work well All passed, but Some binaries report a relocation error: :pg_dumpall undefined symbol...
1
by: Ben Trewern | last post by:
All, There seems to be a bug in pg_dumpall: For one of my dbs I've done: ALTER DATABASE dbname SET search_path = mw, public; If I do a pg_dumpall I get a line like:
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.