[PostgreSQL] Graphical installation PostgreSQL

Schematic installation PostgreSQL

"Bo Master" anti-bone Aberdeen "original address"http://www.cnblogs.com/liqingwen/p/5894462.html

Order

A friend of the "ASP. NET core Project Rights Management System (3) using PostgreSQL through EntityFramework core requires PostgreSQL database, and considering that its subsequent learning also involves the PostgreSQL Database, here is just a simple demonstration under installation and use, for reference only.

Directory

• Brief introduction
• A few things to know before installing
• Start installation
• Post-Installation recommendations
• Simple to use
• GUI Management interface

First, Introduction

PostgreSQL, developed by the computer department at the University of California, Berkeley, has now been renamed PostgreSQL POSTGRES. PostgreSQL supports most SQ L standards and offers many other modern features: complex queries, foreign keys, triggers, views, transactional integrity, MVCC. Similarly, PostgreSQL can be extended in many ways, such as by adding new data types, functions, operators, aggregation functions, and indexes. Free use, modification, and distribution of PostgreSQL, whether for private, commercial or academic use.

Ii. a few things to know before installing

It's all about the plot.

: Http://www.enterprisedb.com/products-services-training/pgdownload#windows, find a suitable one for yourself.

Demo Virtual machine Environment: Win7 x32, installation package name: Postgresql-9.5.4-1-windows.

Three, start the installation

Figure 1 Double-click Run

Figure 2 Click "Next"

Figure 3 Setting up the installation directory

Figure 4 Saving directory for setting data

Figure 5 Set the login password, don't tell me you can't guess my password Oh!

Figure 6 Setting the port number (default 5432)

Figure 7 Setting up a region

Figure 8 finally started to install the

Figure 9 Installation ..., please later ...

Figure 10 Click "Finish" to complete the

Iv. Post-Installation recommendations

Modify the service startup item-set to "delayed start" to reduce system startup pressure.

Now it's still a diagram.

Figure 1 Shortcut key "Win + R" launches "Run" window, enter "Services.msc"

Figure 2 Find the "postgresql-x.x" corresponding to your version, click "Right" to select "Properties"

Figure 3 Change the startup type to Automatic (delayed start)

Five, simple use

Still plots.

Figure 1 Find SQL Shell (psql) boot from the Start menu

Figure 2 Press "Enter enter" directly (the default) and press "Enter key" for a total of 5 consecutive times

Figure 3 "Note" now you enter the password at the time of installation, but the cursor does not move when you enter the password, don't worry, press "Enter enter" when you have finished typing.

Figure 4 Now we try to enter "SELECT 1;". " Note" to add ";" at the end.

Figure 5 Execution OK

Vi. GUI Management interface

I'm sorry, it's an illustration.

Figure 1 Find "Pgadmin III" Start from "Start Menu"

Figure 2 looks like the bird.

[PostgreSQL] Graphical installation PostgreSQL