On 12/6/2016 1:02 PM, David Wall wrote:
You can certainly put the files in a filesystem and point to them, but you'll likely need some access control or people will be able to download any/all PDFs in a given folder. In the DB, you surely will have access control as I presume you don't allow browser access to the DB <smile>.
thats easily remedied by using storage accessed via https or whatever with directory listing disabled, and hashed names. Or, only allow your app server direct access to the file system if its via NFS or whatever.
Either way, you may want to see if your PDFs compress well or not as that may save some storage space at the cost of compress/decompress on accesses.
pretty sure most all PDF's are already compressed, and won't compress much further.
-- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
