topic Re: Postgresql not starting after moving alf_data in Alfresco Archive

Postgresql not starting after moving alf_data

mangar — Wed, 29 Jan 2014 21:29:17 GMT

I am on a windows environment, and installed comm 4.2.e from the installer. I am trying to move alf_data to the 😧 drive. when I do, Postgres service does not start. I see a postgres folder in alf_data, I assume that's the DB files. Where do I change this for postgres to start.

Re: Postgresql not starting after moving alf_data

afaust — Thu, 30 Jan 2014 10:29:24 GMT

Hello,

there should be a postgresql.conf in the postgresql folders where you may have to adapt path configurations when you move stuff around. I do not know if the installer sets up a specific tablespace (I never use the installer), but that may complicate matters as tablespace path information is contained in the meta database and can only be changed after getting the core service working properly.

Regards
Axel

Re: Postgresql not starting after moving alf_data

mangar — Thu, 06 Feb 2014 15:54:40 GMT

the postgresql.conf wont work as postgresql is a service in windows.

After much gnashing of teeth.. here are the instructions for moving alf_data from a windows install.

After a clean startup…

1. shutdown Alfresco
2. shutdown Postgresql
3. Create new location.
3. move every directory from /Alfresco/alf_data (EXCEPT keystore!!! I cannot stress this enough) to new location
4. regedit HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services alfresco postgress. change ImgPath -D parameter to point to the new location
5. start Postgresql, should be no errors.
6. edit /tomcat/shared/classes/alfresco_global.properties dir.root should be the new location - also set the dir.keystore= (line 66) to the orriginal path
7. edit the new location's /alf_data/solr/workspace-SpacesStore/conf/solrcore.properties to the new location
8. edit the new location's /alf_data/solr/archive-SpacesStore/conf/solrcore.properties to the new location
9. edit /tomcat/conf/Catalina/localhost/solr.xml to the new location
10. restart alfresco.

if you get an error at the end about SOLR Model Diff you need to rebuild the indexes.

To Rebuild the indexes:

1. Stop Alfresco
2. Remove index directory of the archive core at alf_data/solr/archive/SpacesStore
3. Remove index directory of the workspace core at alf_data/solr/workspace/SpacesStore
4. Remove cached model info directory of the archive core at alf_data/solr/archive-SpacesStore/alfrescoModels
5. Remove cached model info directory of the workspace core at alf_data/solr/workspace-SpacesStore/alfrescoModels
6. Start Alfresco

Hope this helps someone.

Re: Postgresql not starting after moving alf_data

samnaction — Wed, 02 Apr 2014 14:17:36 GMT

I did this but now I am not able to search in share. It is saying 0 result(s) found in repository