pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Craig Ringer <craig@postnewspapers.com.au>
To: Karsten Hilbert <Karsten.Hilbert@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: column type for pdf file
Date: Thu, 19 May 2011 22:29:47 +0800
Message-ID: <4DD5295B.7060901@postnewspapers.com.au> (raw)
In-Reply-To: <20110519135331.GI2381@hermes.hilbert.loc>
References: <4DD42A1C.30202@encs.concordia.ca>
	<4DD4301F.4010403@ulb.ac.be>
	<20110518210041.GF2498@hermes.hilbert.loc>
	<4DD43867.2040709@ulb.ac.be>
	<4DD47D28.3070207@postnewspapers.com.au>
	<4DD4B1EB.50202@techbaza.pl>
	<4DD51DAA.4010706@encs.concordia.ca>
	<20110519135331.GI2381@hermes.hilbert.loc>

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

view thread (14+ messages)  latest in thread

Message-ID: <4DD5295B.7060901@postnewspapers.com.au>
Permalink:  ../4DD5295B.7060901@postnewspapers.com.au/
Also on:    postgresql.org/message-id/4DD5295B.7060901@postnewspapers.com.au

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: craig@postnewspapers.com.au, Karsten.Hilbert@gmx.net
  Subject: Re: column type for pdf file
  In-Reply-To: <4DD5295B.7060901@postnewspapers.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox