Hi Ricardo,

I would be careful about putting the Datastore in the DB. While I haven't tried 
with postgres, typically DBs aren't as happy dealing with blobs as other 
datatypes. Certainly the performance won't be as good as the filesystem, and if 
your blobs can be big I would not recommend the DB. Reading/Writing the blobs 
occupies the DB-Connections for long periods, potentially changing your 
Repositories behavior under load.
For this reason I would certainly not consider this setting a bug - DataStore 
on Filesystem is the safe and recommended way to set it up.

That said, if your blobs are small it is certainly more convenient to have 
everything in one place...

Regards from Vienna,

Richard

> -----Ursprüngliche Nachricht-----
> Von: [email protected] [mailto:user-list-owner@magnolia-
> cms.com] Im Auftrag von Ricardo Ulate (via Magnolia Forums)
> Gesendet: Donnerstag, 24. April 2014 12:58
> An: Magnolia User List
> Betreff: [magnolia-user] Re: Repositories setup - losing nods with binary
> content
> 
> Hi,
> 
> Your hypothesis is correct.
> 
> The repositories.xml does not contain such information but the file
> jackrabbit-bundle-postgres-search.xml does.
> Indeed it uses the FileDataStore, not DbDataStore.
> 
> More information on this error:
> 
> When using the Postgres database, and not Derby, it seems that the binary
> information is stored in the repositories folder, not in the database. We were
> having an issue with deployments that the repositories folder was getting
> deleted, but of course the database remained intact.
> 
> This caused an inconsistency later on, all binary nodes were now having a
> missing record.
> 
> I'll create a ticket for this issue, because the default configuration 
> provided
> by Magnolia for Postgres uses the FileDataStore in the file, when the correct
> approach should be the DbDataStore.
> 
> --
> Context is everything: http://forum.magnolia-
> cms.com/forum/thread.html?threadId=3b609b75-29cf-48e5-81a6-
> d61fbaceb67e
> 
> 
> ----------------------------------------------------------------
> For list details, see http://www.magnolia-cms.com/community/mailing-
> lists.html
> Alternatively, use our forums: http://forum.magnolia-cms.com/
> To unsubscribe, E-mail to: <[email protected]>
> ----------------------------------------------------------------



----------------------------------------------------------------
For list details, see http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------

Reply via email to