Unix Technical Forum

pg_dumpall 8.1.4 large objects error

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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Admins

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #11 (permalink)  
Old 04-10-2008, 06:16 AM
Jeff Frost
 
Posts: n/a
Default Re: pg_dumpall 8.1.4 large objects error

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:27 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com