How to Install PostgreSQL on Windows Server 2016

Configurare noua (How To)

Situatie

Solutie

Download the Installer

Connect to the Cloud Server with Remote Desktop. Open a browser window and go to the PostgreSQL Windows Installers page. Click Download the installer to download the installer to the server.

Select the most recent version of PostgreSQL and the operating system (Windows x86-64) then click DOWNLOAD NOW.

Install PostgreSQL

  • Open the postgresql-[version]-windows-x64.exe file, which you downloaded in the previous step
  • This will launch the PostgreSQL installation wizard. Click Next to begin the installation process

Specify the directory where you want to install PostgreSQL, then click Next to continue.

Select the components you wish to install. By default, all components will be installed. Click Next to continue.

Select the directory where you want PostgreSQL to store its data, then click Next to continue.

Enter the password you want to set for the database administrative user (postgres). Click Next to continue.

Select the port number you want PostgreSQL to listen on. By default, this will be port 5432. Note: If you wish to access PostgreSQL from the web, you will need to add a firewall policy to allow access to this port.

Click Next to continue.

Select the default locale (time zone) for the PostgreSQL database cluster. Click Next to continue.

Confirm the settings you want to use. If you wish to change any of the settings, click Back until you reach the relevant step. After you have verified that the settings are correct, click Next to continue.

Click Finish to complete the installation.

You can now access PostgreSQL by going to Start > PosgreSQL 10 > pgAdmin or Start > PosgreSQL 10 > SQL Shell (psql).

Tip solutie

Permanent

Voteaza

(1 din 1 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?