Re: Use PSQLFS for photo storage - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Use PSQLFS for photo storage
Date
Msg-id 200901131132.27607@hal.medialogik.com
Whole thread Raw
In response to Use PSQLFS for photo storage  (Jason Long <mailing.list@supernovasoftware.com>)
Responses Re: Use PSQLFS for photo storage
List pgsql-general
On Tuesday 13 January 2009, Jason Long <mailing.list@supernovasoftware.com>
wrote:
> I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
> to store 100 GB of images in PostgreSQL.
>
> Once they are in there I can deal with them.  My main purpose is to use
> rsync to get the files into the database.
>
> Is there a better way to load 20,000 plus files reliably into Postgres?

A perl script using either bytea fields or the lo_ interface via DBD::Pg
would work well.

--
Alan

pgsql-general by date:

Previous
From: Jason Long
Date:
Subject: Use PSQLFS for photo storage
Next
From: Jason Long
Date:
Subject: Re: Use PSQLFS for photo storage