Re: column type for pdf file - Mailing list pgsql-sql

From Craig Ringer
Subject Re: column type for pdf file
Date
Msg-id 4DD5295B.7060901@postnewspapers.com.au
Whole thread Raw
In response to Re: column type for pdf file  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: column type for pdf file  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
On 05/19/2011 09:53 PM, Karsten Hilbert wrote:
> On Thu, May 19, 2011 at 09:39:54AM -0400, Emi Lu wrote:
>
>> All right, it seems that everyone thinks saving a pdf into postgresql
>> is not a good idea.
>
> No.

Hardly everyone. You lose transaction safety when using file system 
storage outside the DB, you need another way to talk to the server than 
just the Pg connection, and most importantly your backups become more 
complicated because you have two things to back up.

It's not simple, and it depends a lot on how much the data changes, how 
big the files are, etc.

--
Craig Ringer


pgsql-sql by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: column type for pdf file
Next
From: Emi Lu
Date:
Subject: Re: column type for pdf file