Select to view content in your preferred language

Where to Enter Script to Install Monitor Database in PostgreSQL 16

110
2
a week ago
JasminePrater
Frequent Contributor

I have installed PostgreSQL 16.8 and am trying to run the script provided in this documentation to create the agm database.  I have searched online and looked around in both pgAdmin and psql and am unable to find the location.  Where can I enter this script so I can create the database?

0 Kudos
2 Replies
MarlonS
Esri Contributor

Hey Jasmine!

You can use the SQL Shell (psql) that comes with the Postgres installation. You can find it by opening the Start Menu and expanding the PostgreSQL folder on the machine where PostgreSQL is installed.

MarS_2-1741195896106.png

 

Once you open the SQL Shell, you'll be prompted to connect to the default Postgres database. Personally, I enter the values in the bracket, my install is default:

MarS_1-1741195365302.png

After, you can paste the script into the SQL Shell after making your edits, and it should run; you may have to hit enter on the "GRANT ALL" command to complete the script.

I hope this helps!

 

StevenB
Occasional Contributor

I prefer a GUI interface and like to use pgAdmin 4 for this process.
Once logged in as a DB Admin user, 'postegres' by default you can right click on your default 'postgres' DB and choose Query Tool > Then Copy Paste the SQL commands from the AGM Help > fill in a password and run each block separately by highlighting and choosing 'Execute script'.  

StevenB_0-1741196955258.pngStevenB_1-1741197010421.png