How to Install PostgreSQL /PG Admin and connect your mendix application with database backup. This is very useful if we need to fix any issue/do POC and not able to perform action in higher instance.

5

How to Install PostgreSQL /PG Admin and connect with your mendix application with database backup. This is very useful if we need to fix any issue/do POC and not able to perform action in higher instance.

Step:1- First download and install the PostgreSQL using below link.

PostgreSQL: Downloads

Step:2 — Install the pgAdmin4 using below link, choose Recommended one and Complete the Installation.

PG Admin Download

Step:3 After pgAdmin4 installation, Open pgAdmin 4 and set the password, please remember this password, it will used during mendix studio pro pgAdmin connect.

Step4: - Go to File-Preferences-Paths-Binary Path and enter path with your user id.

C:\Users\abcd\AppData\Local\Programs\pgAdmin 4\v6\runtime

Step5 :- Right Click on Server and register the server.

Step6: — Create database with App name which you want to run in locally.

Step7: Right Click on database and click on restore, Go to General and select the database backup file(we can get database file from mendix sprinter backup section).

Go to Data/Object and enable Owner.

Step8: Go to Mendix studio pro , settings-configuration-database

Type: — PostgreSQL

Database Name: — Enter the name running in pgAdmin 4 local.

Enter username and password given during server creation in pgAdmin.

Click on run Locally in Mendix and you can debug any issue /do any POC using Accp/UAT database in local run.

Posted 2025-04-07

5 comments