Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id EA8F71337B5D for ; Mon, 29 Nov 2010 12:50:08 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 87551-03 for ; Mon, 29 Nov 2010 16:50:00 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm5-vm0.bullet.mail.ne1.yahoo.com (nm5-vm0.bullet.mail.ne1.yahoo.com [98.138.90.251]) by mail.postgresql.org (Postfix) with SMTP id 264251337B5E for ; Mon, 29 Nov 2010 12:49:59 -0400 (AST) Received: from [98.138.90.57] by nm5.bullet.mail.ne1.yahoo.com with NNFMP; 29 Nov 2010 16:49:59 -0000 Received: from [98.138.89.232] by tm10.bullet.mail.ne1.yahoo.com with NNFMP; 29 Nov 2010 16:49:59 -0000 Received: from [127.0.0.1] by omp1047.mail.ne1.yahoo.com with NNFMP; 29 Nov 2010 16:49:59 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 396632.47921.bm@omp1047.mail.ne1.yahoo.com Received: (qmail 98075 invoked by uid 60001); 29 Nov 2010 16:49:59 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1291049399; bh=xZl5gRvDBKZunSdi2H+QgMVb/oAlA5t6NN27Surr+Eo=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=nNeBpasOvShw0LlXp3gRvF16KiAHOm22jtLG/Go2KF+HTHqhjxhrMuhoDRcDhrtw3vtgbwllf5xssBCt2dmLDGhAAgUQIQ9FF4RLG7cxgGDy/BQD4oYe3DVSynTNE76fDk9xh7+vMPFhu0pK7Ou4tmu1VvGuHaD1ZWddprKeS/8= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=cryf2x0uAqTsfdTlvUwfhqc2RgQnpVoKvTExzWVbOa0kikqkBj252lCTkENQP9Y0SVCpHkW1yikkRhwLZ+7Krin9mVyd1DHy5zkUuQOSU6gFLA2ZbNnrxsVGQrhTJyk7BaRVEHvddbhmX5AtbgdHdhmbJlCad9xVsfhpyBRTzKs=; Message-ID: <299295.96835.qm@web120001.mail.ne1.yahoo.com> X-YMail-OSG: _KeicSkVM1kWF8rfUuNEG1ZRcDDgctEWMB2NXzCu7bxUSrq xdDmAGqlFJlIjIA_qxRl.IV3YdMkP3WeUcD0ZURoGPv1hCPSElYGburYfI3i O9gcQE5Ul_p28uTjI0vGyQXLcVqEMbKlVR_Jq2P9qSaSjoHuZrFh69mN8qYw jcZiAN_OxF9YuBpxUhY7Pc1dRMv_WC0Ouj0zZ Received: from [68.36.212.155] by web120001.mail.ne1.yahoo.com via HTTP; Mon, 29 Nov 2010 08:49:59 PST X-Mailer: YahooMailRC/553 YahooMailWebService/0.8.107.285259 Date: Mon, 29 Nov 2010 08:49:59 -0800 (PST) From: A J Subject: Extension for file management under postgres To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-603473681-1291049399=:96835" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.773 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_FONT_FACE_BAD=0.981, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: * X-Archive-Number: 201011/237 X-Sequence-Number: 36203 --0-603473681-1291049399=:96835 Content-Type: text/plain; charset=us-ascii Does anyone know of a module for postgres that can do metadata management in postgres but actual storage of binary objects in filesystem ? Not really using Postgres large object but want to just do the metadata management with postgres. Example, need to store file name/size/directory/drive/node in postgres but the actual file in a filesystem. Also utilities that will all to do file rename (and metadata rename) within a single transaction. Similarly file delete or file copy as well. Also maybe webdav or ftp extensions to do get/put from web front. (the metadata would be from postgres and actual object from filesystem) This sounds like a typical exercise and don't want to reinvent if the code is already out there. many thanks ! -AJ --0-603473681-1291049399=:96835 Content-Type: text/html; charset=us-ascii
Does anyone know of a module for postgres that can do metadata management in postgres but actual storage of binary objects in filesystem ?
Not really using Postgres large object but want to just do the metadata management with postgres. Example, need to store file name/size/directory/drive/node in postgres but the actual file in a filesystem.
Also utilities that will all to do file rename (and metadata rename) within a single transaction. Similarly file delete or file copy as well.
Also maybe webdav or ftp extensions to do get/put from web front. (the metadata would be from postgres and actual object from filesystem)

This sounds like a typical exercise and don't want to reinvent if the code is already out there.

many thanks ! -AJ

--0-603473681-1291049399=:96835--