On Friday 04 August 2006 02:20, Josh Berkus wrote:
> <grin> Aren't I, the marketing geek, supposed to be the one whining about
> this?
> > * In-place upgrades (pg_upgrade)

> BTW, I may get Sun to contribute an engineer for this; will get you posted.

Long time no post.  This statement really caught my attention; bravo if true 
upgrading can happen, and someone can be put on it and do it right.

As Tom said, a little farther down the thread, we have talked over this many 
times.  I specifically remember, oh, about a dozen times I personally 
have 'gadflied' this issue.

As one who now has a, let's see: 
[EMAIL PROTECTED] ~]# du /var/lib/pgsql/data -s
16668528        /var/lib/pgsql/data

Yes, a 16GB inventory database, with in-database large object images.  Anyway, 
as one who does not look forward to migrating this the old-fashioned way (I 
can just imagine how fas^H^H^Hslow a restore of all those large objects is 
going to be; backup is slow enough (about 50 minutes on this Xeon 2.4GHz 
box)), in place upgrade would cut this considerably; the database is not a 
complex one, just a largish one.  It's, let's see, only holding a little less 
than 5,000 items with associated lo images (due to many factors, this is 
handled through ODBC from Microsoft Access; it is a kludge, and a big one, 
but it works very smoothly from the users' points of view, where item images 
are literally 'dragged and dropped' from the digital camera straight to the 

So, anyway, looking forward to seeing some progress in this department... :-)
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC  28772

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to