nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Access Portal PostgreSQL

MuhammadNaufalIhsan

Hi guys,

Does anyone know how to access the portal PostgreSQL? In datastore, I can use the listadminusers utility tools to get the username and password to access the database. However, I cannot find the same tools in the portal.

Regards,

Naufal

Find more posts tagged with

Accepted answers

jskinner

@MuhammadNaufalIhsan ,

Note: Exercise extreme caution when connecting to Portal's PostgreSQL database

1. Open command prompt

2. Change the directory to portal's PostgreSQL bin directory. Ex:

c:\arcgisportal\pgsql_14.5\bin

3. Connect using the initial Portal Administrator username/password when portal was installed:

If you do not know the username/password, this can be updated through Portal Administrator Directory > System > Database:

All comments

jskinner

@IqbalRidwan yes, the Portal service will restart:

IqbalRidwan

Hi @JakeSkinner

Good day!

May I know if there is any downtime we can expect once we change the password and does it affect anything on the Portal/ArcGIS Enterprise itself? Etc: services restart/crash

I am looking forward to hearing from you.

Regards,

Iqbal

MuhammadNaufalIhsan

Hi Jake,

Thanks for the answer! We've tried this and it worked!

Regards,
Naufal

MuhammadNaufalIhsan

Hi Miguel,

Thanks for the answer! We haven't tried this solution yet since the other solution worked. But again, thanks for answering!

Regards,

Naufal

jskinner

@MuhammadNaufalIhsan ,

Note: Exercise extreme caution when connecting to Portal's PostgreSQL database

1. Open command prompt

2. Change the directory to portal's PostgreSQL bin directory. Ex:

c:\arcgisportal\pgsql_14.5\bin

3. Connect using the initial Portal Administrator username/password when portal was installed:

If you do not know the username/password, this can be updated through Portal Administrator Directory > System > Database:

MiguelParedes

Greetings @MuhammadNaufalIhsan

Navigate to <drive>:\Program Files\ArcGIS\Portal\tools\createportal and use the command "listadministratorusertypes"

Usage: listadministratorusertypes -lf <arg>
<arg> is the path to the portal license file. The tool will list the user types compatible with the Administrator role that are in this license file.

Hope that helps.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.