topic Re: Access Portal PostgreSQL in ArcGIS Enterprise Portal Questions

Access Portal PostgreSQL

MuhammadNaufalIhsan — Mon, 18 Sep 2023 06:24:46 GMT

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

Re: Access Portal PostgreSQL

MiguelParedes — Mon, 18 Sep 2023 07:14:02 GMT

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.

Re: Access Portal PostgreSQL

JakeSkinner — Mon, 18 Sep 2023 12:56:47 GMT

@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:

Re: Access Portal PostgreSQL

MuhammadNaufalIhsan — Tue, 19 Sep 2023 03:14:01 GMT

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

Re: Access Portal PostgreSQL

MuhammadNaufalIhsan — Tue, 19 Sep 2023 03:15:06 GMT

Hi Jake,

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

Regards,
Naufal

Re: Access Portal PostgreSQL

IqbalRidwan — Wed, 22 Oct 2025 02:33:14 GMT

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

Re: Access Portal PostgreSQL

JakeSkinner — Wed, 22 Oct 2025 11:28:05 GMT

@IqbalRidwan yes, the Portal service will restart: