Thanks for all the tips. After a fresh install, when I run setup_db, I still get the following error, pasted below.
On the app server, I can connect to the database server without issue using pgAdmin. I have created the blank db for Arches there, as per Ryan's suggestion. The postgis template exists on the server and I used it as a template to create the db. This should not be a port issue since I am able to connect with pgAdmin.
(ENV) C:\Projects\arches_parks>python manage.py setup_db
Are you sure you want to destroy and rebuild your database? [y/N] y
Drop and recreate the database...
SELECT pg_terminate_backend(pid) FROM pg_stat_activity
WHERE datname IN ('azure_arches', 'template_postgis');
Traceback (most recent call last):
File "manage.py", line 30, in <module>
execute_from_command_line(sys.argv)
File "C:\Projects\ENV\lib\site-packages\django\core\management\__init__.py", line 381, in execute_from_command_line
utility.execute()
File "C:\Projects\ENV\lib\site-packages\django\core\management\__init__.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\Projects\ENV\lib\site-packages\django\core\management\base.py", line 323, in run_from_argv
self.execute(*args, **cmd_options)
File "C:\Projects\ENV\lib\site-packages\django\core\management\base.py", line 364, in execute
output = self.handle(*args, **options)
File "C:\Projects\ENV\lib\site-packages\arches\management\commands\setup_db.py", line 52, in handle
self.setup_db()
File "C:\Projects\ENV\lib\site-packages\arches\management\commands\setup_db.py", line 186, in setup_db
self.drop_and_recreate_db(cursor)
File "C:\Projects\ENV\lib\site-packages\arches\management\commands\setup_db.py", line 137, in drop_and_recreate_db
cursor.execute(terminate_sql)
psycopg2.errors.AdminShutdown: terminating connection due to administrator command
SSL connection has been closed unexpectedly