Hi Ryan, Thanks, this is very helpful. That's pretty much what I had already tried. On the app server, I had used PGAdmin to connect to the db server and the connection was successful. Using pgAdmin, I had also created the blank db with the PostGIS template on it.
It sounds like I just need to try again and double-check the settings file. I'll report back my findings. Markus On Wednesday, April 14, 2021 at 11:15:41 AM UTC-7 Ryan Anderson wrote: > 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/657bf66c-dd85-49b0-8567-d6c50e2ef793n%40googlegroups.com.
