Re: orthanc-postgresql
On Mon, Mar 02, 2015 at 01:59:41PM +0100, Sébastien Jodogne wrote:
> > Delightedly I have noted that PG can be used to store both of
> > index _and_ the actual DICOM instances (?).
>
> Yes, you're right: Enabling the "libOrthancPostgreSQLStorage.so" will store the DICOM instances into PostgreSQL (and not on the filesystem).
That makes it a lot easier to take consistent backups.
> > If so, I'd be interested to know which way you chose to store
> > DICOM instances inside PG -- by means of BYTEA columns or as
> > large objects ?
> >
> > http://www.postgresql.org/docs/9.4/static/datatype-binary.html
> > http://www.postgresql.org/docs/9.4/static/largeobjects.html
>
> The plugin uses large objects.
OK, good. That way they can be up to 4 TB in size (as opposed
to 1 GB of BYTEA).
http://michael.otacoo.com/postgresql-2/playing-with-large-objects-in-postgres/
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
Reply to: