cancel
Showing results for 
Search instead for 
Did you mean: 

Postgresql not starting after moving alf_data

mangar
Star Contributor
Star Contributor
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.
3 REPLIES 3

afaust
Legendary Innovator
Legendary Innovator
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

mangar
Star Contributor
Star Contributor
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.

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