PostgreSQL 16 & pgAdmin4 on Windows Server 2022
Jun 28, 2024
Search for Services
Click ServicesSearch for the Service – postgresql-x64* > Double Click
From the above menu you can reconfigure the service to not start on boot, stop, start and or
restart the service manually.
pgdmin4
A connection to the postgresql database running on the instance can be made from the
pgAdmin4 programme preinstalled. You can access the program via the Desktop .exe shown
below as the Administrator user.
On first boot of the programme, you will be prompted to set a new master password to be
used for securing & unlocking later defined passwords.Enter your preferred password value for the above.Select ‘Add New Server’
Enter a NAME for the new connection, in this example we will use EXAMPLE but any value
could be used.
Click ConnectionHost: localhost
Port: 5432
Username: postgres
Password: REFER TO THE RANDOMLY GENERATED PASSWORD VALUE FOUND IN THE
postgres-credentials.txt FILE FOUND ON THE DESKTOP OF THE ADMINISTRATOR USER.
Click SaveYou have now successfully connected to the locally running postgres database instance.
SQL Shell (psql)
SQL Shell has also been preinstalled on the system. You can access this programme via the
below icon located on the Desktop of the Administrator user.Upon starting the programme, you will be prompted for the below inputs.
Server: localhost
Database: postgres
Username: postgres
Password: REFER TO THE RANDOMLY GENERATED PASSWORD VALUE FOUND IN THE
postgres-credentials.txt FILE FOUND ON THE DESKTOP OF THE ADMINISTRATOR USER.
Once successfully connected, you will now be able to perform postgres database
administration tasks from the command line interface.">