Re: Use PSQLFS for photo storage

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Use PSQLFS for photo storage
Date: 2009-01-13 19:32:27
Message-ID: 200901131132.27607@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 13 January 2009, Jason Long <mailing(dot)list(at)supernovasoftware(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Long 2009-01-13 19:40:40 Re: Use PSQLFS for photo storage
Previous Message Nykolyn, Andrew 2009-01-13 19:11:31 Re: Cast for text->Integer missing in 8.3.5