Hi Markus, I've done this a bunch with Amazon's RDS service. It sounds like generally you are on the right track. More detail about the errors you're seeing would be helpful, but I'll try to recount additional things that may be necessary here.
First, check that your postgres port is open on your db server (usually this is 5432) and accessible from your application server. Sometimes I do this by installing psql on the application server and trying to connect to the db server with that. On AWS there are some network settings that need to be tweaked to make sure that the application and db server can talk to each other. The command to connect should be something like this: `psql -U username -h db_server` If this works, then add a postgis template to your db instance (instructions for this can be found here <https://postgis.net/install/>) and then try manually creating your project database from this template in psql. This will get overwritten when you run setup_db/load_package in Arches, but sometimes Arches likes to see that there is already a database there. If things are still not working at this point then double check your settings/settings_local.py file. Arches does not require that you have postgres server installed on the application server, but it is usually helpful in these situations to have the psql client installed - which requires you to select a version you would like it to work with. I hope this helps. Post back with any updates or additional info. Cheers, Ryan On Wednesday, April 14, 2021 at 10:51:21 AM UTC-7 Markus S. wrote: > Hi, > > Does anyone have experience installing Arches 5.1 using two servers, one > for the web server/app and one for the PostgreSQL database? I'm looking at > doing that on Azure. It does not seem as simple as just setting the > database server host name and port in the settings file (I tried it). > Furthermore, the Arches app installation process seems to require the > Postgre 12 dependency on the app's server, implying that the default > expectation is that the db and the app reside on the same server. > > Any tips on this would be appreciated. > > Markus > -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/faf2a658-b853-4264-980d-0ac537746e96n%40googlegroups.com.
