Restoring datastore filesystem to DB
PostPosted:Mon May 09, 2016 11:24 am
by Jahangir
Hi,
I want to move files stored on file system (datastore) to newly configured postgres db. Is there any way i can import datastore to postgres db.
Regards,
Jahangir
Re: Restoring datastore filesystem to DB
PostPosted:Wed May 11, 2016 6:05 pm
by jllort
First of all I must encourage do not doing it. Is not a good idea save binary information into database, will dramatically increase and will be really hard doing backups on it. Is always better backup small database and make incremental backup from filesystem. Secondly, you will get less perfomance, for downloading a file, now, from database will be created temp file and then created and stream to retrieve it. If the document is yet in the file system, the temp file is not created, directly is used for retrieving.
Finally for doing it, you should export and import entire repository.
Re: Restoring datastore filesystem to DB
PostPosted:Mon Jun 06, 2016 10:18 pm
by alaust
no you cant do it because if you do it it wont work