In this topic we provide basic documentation to a quick database setup with PostgreSQL.
We provide no further support regarding this topic.
Start by downloading an open source PostgreSQL package and installer from EDB: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
The last version we tested was PostgreSQL Version 16.3 and this worked.
After downloading the required packages and installers, you execute the downloaded installer.
Follow the standard steps in this installation proces but mind the following configurations.
Make sure you select and install all components for you will need them to complete the setup.
Choose the password for the database superuser (named postgres). Later we will need this password.
Enter Port number "5432".
Select the "locale" to be used by the new database cluster. In our example we select the [Default locale].
After the Pre Installation Summary all settings are provided. Click "Next" until the installation process is completed.
Normally Stack Builder will automatically start up. Stack Builder will provide the necessary intermediate software to connect the database to MS Excel in a later stage.
Select the software you use, in order to download the correct additional software. In our example we need PostgreSQL 16 (x64) on port 5432.
In our case we only need the Database Driver for psqlODBC (64bit) v13.02.0000-1.
Complete the installation process after choosing the download directory. This is the last configuration you need to fill in.
Now you installed to necessary software to create a database, you start up pgAdmin 4.
You see the following dashboard:
Create a new database via the menu "Object > Create > Database...".
Enter the desired name of the database and select the owner of the database.
In our example this is "octopus_power_bi" and the superuser "postgres".
Click "Save" and the database is created.
The next step is to start up our Octopus Database Connecter.