Is there any way to configure Alfresco to connect to a Postgres database on a computer on the same network (or perhaps a computer that is connected to the internet even)?
I went through the instructions in the Alfresco documentation here, but that is only setup for running the Postgres server on your own computer. I tried editing it a bit, by making a few changes. I changed db.url to "jdbcostgresql://192.168.1.11:5431/${dbname}" in the alfresco-global.properties file. I would think this would make it connect to the remote Postgres database instead of the one on my computer, but it gives me an error each time I try to login, saying "The remote server may be unavailable or your authentication details have not been recognized." The other computer has had the proper databases and users created.
Is there a step I'm missing while trying to set this up?
Actually I figured out how to get it working. I had to edit the share-config-custom.xml file in [Alfresco_home]\Tomcat\shared\classes\alfresco\web-extension. instead of saying localhost, it needs the ip address of the host computer.
For connecting to a remote database host, no changes below shared/classes/alfresco/web-extension (share-custom-config.xml) has to be done.
The Alfresco share webapp (share.war) can be configured to use a remote Alfresco repository webapp instance (alfresco.war) this way.
This is very different than using a remote database for the Alfresco repository webapp (alfresco.war), which is configured in the alfresco-global.properties file only (db.url=jdbcostgresql://rem.ote.iph.ost/ALFRESCO entry).