Install postgres on windows

Note: PostgreSQL runs as a background process under a service called postgres. If you already have a service named postgres running, enter the password for that service account when prompted. When entering a custom port number, make sure no other applications are using the port.

Choose the locale for the database to use. Selecting the [Default locale] option uses the locale settings for your operating system.

Once you have chosen a locale, click Next to continue. The last step offers a summary of the installation settings. Click Back if you want to change any of the settings you made, or click Next to proceed. The setup wizard informs you it is ready to start the installation process. Enter the information for your database as defined during the setup process. Pressing Enter applies the default value, as shown in the square brackets. Note: pgAdmin requires you to set a master password at first launch.

Right-click the Servers icon on the left-hand side. In the General tab, enter the name for the new database. In this example, we are using PostgreSQL as the database name. In the Connection tab, enter the hostname default is localhost and password selected during the setup process. Click Save to create the new database. Select the default postgres database.

In the Tools drop-down menu, click Query Tool to open the query editor. Verify the database in the query editor by entering the following command and clicking the Execute button:. If the database is working properly, the current version of the database will appear in the Data Output section.

This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developing your databases, and StackBuilder; a package manager that can be used to download and install additional PostgreSQL tools and drivers. Stackbuilder includes management, integration, migration, replication, geospatial, connectors and other tools. The installer is designed to be a straightforward, fast way to get up and running with PostgreSQL on Windows. Advanced users can also download a zip archive of the binaries, without the installer.

This download is intended for users who wish to include PostgreSQL as part of another application installer.