Hi Markus, I use this setup for my installations. It works as expected, but you make a few good points. This is definitely a section of the documentation I've been wanting to update for a while... https://github.com/archesproject/arches-docs/issues/115
For your Azure connection issues, like Ryan said it could be a firewall issue. Make sure your db server allows access via port 5432 from your app server. On AWS I found that I needed to allow access from the app server's *private* ip address, not public one, to facilitate this connection. Easiest of course would be to open up 5432 to any incoming connections, but that's not a very secure solution.... As for the local postgres installation, originally arches did require the postgres client pqsl locally to facilitate all of the setup_db commands, but we've tried to factor that out ( https://github.com/archesproject/arches/issues/4803). It's really a consequence of relying for a long time on an installation process that expects a postgres superuser (discussed a bit here: https://github.com/archesproject/arches/issues/2636). Ultimately, you can now run all of the normal arches development management commands without having postgres/psql locally, but you will need to create your database ahead of time and add the postgis and uuid-ossp extensions to it. Hope that helps a bit, Adam On Wed, Apr 14, 2021 at 1:26 PM Markus S. <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/archesproject/657bf66c-dd85-49b0-8567-d6c50e2ef793n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- -- 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/CAGYBTaviDGQURwqfaGtbxps3VPJQs%2BnGognWs2duoNdZbKm76Q%40mail.gmail.com.
