topic Alfresco on Postgresql + samba as files storage in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-on-postgresql-samba-as-files-storage/m-p/250273#M203403 <HTML><HEAD></HEAD><BODY><SPAN>Hello </SPAN><BR /><SPAN>I'm new to Alfresco and I would like to choose optimal program for file management. I work in geodesy. We use samba server (PDC) to store multipaged .tif (scans). It is about 70000 files ~500GB and each day this number increases. We would like to share files surveyor by internet.</SPAN><BR /><BR /><SPAN>So my main question is it is possible by alfresco ?</SPAN><BR /><SPAN>Alfresco is on mysql database we would like to use postgresql because we have a lot of information about files and jobs.</SPAN><BR /><SPAN>- how can i install alfresco on Postgresql ? May I have any problems with update Alfresco in future relases? How make postgresql structure for Alfresco ?</SPAN><BR /><BR /><SPAN>We have postgresql database which store the paths to scan (eg. W:\2010\189_10.tif )(putting .tif files to database will decrease database performance).So I uploading this scans to alfresco will decrease performance too.</SPAN><BR /><BR /><SPAN>I would like to Alfresco store only links to scans (which physically will be stored on samba share eg.:</SPAN><BR /><SPAN>\\server\scans\2010\129_10.tif )</SPAN><BR /><SPAN>\\server\scans\2009\8995_09.tif</SPAN><BR /><SPAN>and information about files.&nbsp; All rest files propoerties/descriptions eg. type of geodesic work, we have on postgres so a would like to alfresco automatically load this info.&nbsp;&nbsp; Our clients (surveyors) who wanted to see the scan could see this and all of its properties/descriptions.</SPAN><BR /><BR /><SPAN>Because multipaged .tifs&nbsp; are not good for internet sharing we would like to alfresco automatically convert it from multipaged tiff to .PDF which is internet optimized file. </SPAN><BR /><BR /><SPAN>How can I do it ? It is possible to make it in Alfresco or better use another system like Liferay or something which I even don't know name ??</SPAN><BR /><BR /><SPAN>Could you give me links or other info how to install Alfrsesco on postgresql which packages I need (LINUX centos 5.5) and May I need any additional plugins to convert multipaged tiff to pdf and fast share by internet ????</SPAN></BODY></HTML> Fri, 05 Nov 2010 11:30:51 GMT hubercior 2010-11-05T11:30:51Z Alfresco on Postgresql + samba as files storage https://connect.hyland.com/t5/alfresco-archive/alfresco-on-postgresql-samba-as-files-storage/m-p/250273#M203403 Hello I'm new to Alfresco and I would like to choose optimal program for file management. I work in geodesy. We use samba server (PDC) to store multipaged .tif (scans). It is about 70000 files ~500GB and each day this number increases. We would like to share files surveyor by internet.So my main que Fri, 05 Nov 2010 11:30:51 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-on-postgresql-samba-as-files-storage/m-p/250273#M203403 hubercior 2010-11-05T11:30:51Z Re: Alfresco on Postgresql + samba as files storage https://connect.hyland.com/t5/alfresco-archive/alfresco-on-postgresql-samba-as-files-storage/m-p/250274#M203404 <HTML><HEAD></HEAD><BODY><SPAN>Yes Alfresco supports Postgressql as well as mySql.</SPAN><BR /><BR /><SPAN>And you can put Alfresco's content store on a samba drive.</SPAN></BODY></HTML> Sun, 07 Nov 2010 21:54:41 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-on-postgresql-samba-as-files-storage/m-p/250274#M203404 mrogers 2010-11-07T21:54:41Z Re: Alfresco on Postgresql + samba as files storage https://connect.hyland.com/t5/alfresco-archive/alfresco-on-postgresql-samba-as-files-storage/m-p/250275#M203405 <HTML><HEAD></HEAD><BODY><SPAN>Could you give any information about installation and configuration on postgresql. How Can I make database schema? It isn't do automatically . Where in Alfresco can I setup samba shares to view files?</SPAN></BODY></HTML> Mon, 08 Nov 2010 08:03:17 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-on-postgresql-samba-as-files-storage/m-p/250275#M203405 hubercior 2010-11-08T08:03:17Z