How do you install the PostgreSQL database on Windows?

Download installer from (https://www.enterprisedb.com/downloads/postgres-postgresql-downloads) for Windows.

Open the installer you downloaded and click Next.

If you want to change the default installation path change it and click Next. The default installation directory is C:\Program Files\PostgreSQL\17.

Select all of the components and click Next.

Choose default data directory and click Next. This one you many want to change to your own preferences.

Set password for superuser (postgres) . Do NOT FORGET the Password.

The default port will be 5432 and click Next. It will take few minutes to finish installation. On newer computer it may only take a minutes or so.

I did not install anything from here.

pgAdmin 4

pgAdmin will be installed. Run it. The interface opens. Click Servers on the left side. You will see your version listed. Mine says PostgreSQL 17. The next thing that happens is a dialog box appears asking you for your password. Enter it and you will see something like the following screenshot.

On the left you can see the word Databases. This is where you create your databases.

PostgreSQL Shell

In Windows, look for the program psql. It’s like a command prompt.