Installing PostgreSQL on Windows for the first time can be a little intimidating and you might be left wondering if you even did it right. Follow this guide and rest assured you will have a properly installed PostgreSQL database on Windows.
Head on over to EntrepriseDB.com and download the latest version of Postgres for your version of windows.
Now that Postgres is downloaded, run the file to start the installation process.
Just like any other executable file you download, you will be asked if you want to "allow this app to make changes to your pc".
Nothing to see here, just click Next.
Choose where you want to install PostgreSQL.
Select what components to install (If you're not sure, it's fine to install everything).
Choose where to store your database.
PostgreSQL comes with a default user and database called postgres. Set the password for that user here.
Note: You can change this password later through the psql shell using the SQL language.
Choose the port that your projects will connect to the PostgreSQL server on. This can be almost any port you'd like but you will see most people using the default 5432.
You will probably want to set this to the language you speak in your home country.
Before clicking Next, just make sure all the settings are how you want them.
Click Next to start installing. This will take a few minutes while the PostgreSQL server and tools are installed and the PostgreSQL server is started.
When the installation finishes, if you had chosen to install the stack builder component earlier in this tutorial you will be shown the following screen. Most developers new to PostgreSQL won't need the tools that come with stack builder until they get more comfortable with it. Uncheck the box and click Finish.
That's it! That is all there is to installing a real working PostgreSQL database server on your windows machine. You are now ready to connect to it and store your projects data! Don't know where to start next? Check out our basic windows setup tutorial for PostgreSQL to get you going.
© Cloud Giant 2023. All rights reserved