Installation and use of PostgreSQL under Windows

Source: Internet
Author: User
Tags postgresql psql

First, download

Select the version you want to download from Http://www.enterprisedb.com/products-services-training/pgdownload#windows, I am operating under the Win7 64 bit, The download is 9.4.4 version Http://get.enterprisedb.com/postgresql/postgresql-9.4.4-3-windows-x64.exe

Second, installation

Double-click Run, such as:

Select Next, such as:

Select the installation directory (I choose the default, or I can choose the installation path), select Next:

Select the Data directory (I choose the default, or I can choose the installation path), select Next:

To set the password for the Administrator account, select Next:

Select the boot port (default is 5432) and select Next:

Select the installation code, select C, and select Next:

Select next to start the installation

This step is completed, the extension tool can not be installed.

Third, the operation1. Find PostgreSQL in the program, such as:

You can use Pgadmin III's graphical interface or SQL Shell (Psql), which is recommended with the SQL Shell command line interface, run as follows:

The first is to select the server, the default is local, and other servers to enter the IP or host name, the second is the database name, the default is Postgres;

The third is the port, the default is 5432, the fourth is the user name, the default is Postgres, and then enter the password can be connected.

Then you can use it and quit using \q.


2. It can also be done with the Windows command line like Linux:

Press the shortcut key win+r to run CMD first:

Then run Psql:

Installation and use of PostgreSQL under Windows

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.