This is a discussion on pg_dumpall 8.1.4 large objects error within the pgsql Admins forums, part of the PostgreSQL category; --> On Sat, 10 Jun 2006, Jeff Frost wrote: >> I'm running a test dump now, so we'll see sometime ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| On Sat, 10 Jun 2006, Jeff Frost wrote: >> I'm running a test dump now, so we'll see sometime tomorrow (it takes about >> 20 hrs with the current setup) if it worked properly or if I find a new >> problem. :-) > > You'll be happy to hear that the test dump was successful and actually only > required 12 hrs to complete. Now that we can create a valid db dump, we'll > be doing the upgrade as soon as a maintenance window presents itself. Server is now up and running on 8.1.4 and much happier for it! The restore only took about 5 hours compared with 12 hours to dump! Wow, I guess we've had a few performance enhancements between 7.3 and 8.1. :-) Thanks for all the help as always! -- Jeff Frost, Owner <jeff@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |