Received: from cr322781-a.ym1.on.wave.home.com (cr322781-a.ym1.on.wave.home.com [24.112.37.89]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eASJWLt68902 for ; Tue, 28 Nov 2000 14:32:21 -0500 (EST) (envelope-from svanegmond@bang.dhs.org) Received: from svanegmond by cr322781-a.ym1.on.wave.home.com with local (Exim 3.16 #1 (Debian)) id 140qW2-000802-00; Tue, 28 Nov 2000 14:34:10 -0500 Date: Tue, 28 Nov 2000 14:34:10 -0500 To: Mitch Vincent Cc: svanegmond@home.com, chriswood@wvda.com, pgsql-php@postgresql.org Subject: Re: Question re large objects Message-ID: <20001128143410.A30737@bang.dhs.org> Reply-To: svanegmond@home.com References: <3A23B26E.9056.2942B3@localhost> <20001128132923.B30495@bang.dhs.org> <011201c05976$c76df8e0$0200000a@windows> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <011201c05976$c76df8e0$0200000a@windows>; from mitch@venux.net on Tue, Nov 28, 2000 at 12:07:04PM -0800 From: Stephen van Egmond X-Archive-Number: 200011/29 X-Sequence-Number: 37 Mitch Vincent (mitch@venux.net) wrote: > > Because you will lose the images when you do a restore from backup. > > And you will have to restore from backup eventually, count on it. > > I think one should always plan for the worst case scenerio, that's exactly > thye you do backups, so you don't lose data.. Why would he lose data if he's > preforming backups and restored from that backup.. BLOBs are not dumped from pgsql. This might be because there's no valid SQL to create BLOBs, and since pgsql dumps are supposed to be SQL, it just doesn't work. > Again, I always think one should make an application scaleable but having > said that, I think what you're mentioning here is a cart before the horse > situation. Even saying he needed to load balance I'd never use NFS, ever. > Large RAID arrays and such could provide all the storage needed -- > especially since we're just talking about images here. I'm referring to multiple serving machines due to CPU or local disk capacity. > I'd suggest that you don't use OIDs as binding record IDs, make another > integer field for that. There is an option to pg_dump to preserve OIDs even > if you do. I don't think you understand large objects. When you create one, you get an OID. When you want to retrieve it, you hand it the OID. End of story. And, again, they are dumped by pg_dump.