Steven Lembark 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?
>>
>
> Don't: put them into a reasonably-organized filesystem
> and store the paths.
This is exactly what I do not want to do. I do not want to deal with
the file system at all except for initial import. I want to manage the
photos entirely with SQL.
> I use dir names of date-venue-descr
> and basenames of the dir-image number (e.g.,
> "2009.01.12-foo-bar/123-4567.nef"). You'll probably find
> that moving the data into a viewer using a path will be
> simpler than pumping the raw data through postgres
> anyway.
>
Please explain. What does moving the data into a viewer using a path mean.
> At that point you could create COPY statements that look
> like a pg_dump output to load the stuff the first time.
>
>
Please elaborate.
>
>