How to download and configure Windows PostgreSQL database

Today, open source PostgreSQL ...

This is the PostgreSQL official website, you can download the corresponding version

http://www.postgresql.org/

Here's A

PostgreSQL 9.3.1 Chinese Handbook

Http://www.postgres.cn/docs/9.3/index.html

PostgreSQL 9.3.1 Chinese Manual 1.1 release notes

https://github.com/postgres-cn/pgdoc-cn/releases/tag/v9.3.1-1.1

Here's A

PostgreSQL Wiki

Https://wiki.postgresql.org/wiki/Main_Page

Download the free installation version or after installation, then the configuration of PostgreSQL:

The first is to create the Psql service, otherwise you cannot start the database:

installation directory for 1.Postgress: D:\2016\pgsql

2. Create a data directory, store the database, switch to the bin directory CDd:\ \pgsql\bin

3. Initialize data, initdb-d d:\ \pgsql\data-eUTF8

-D: Specifies the storage directory for the database cluster D:\2016\pgsql\data

-e: The user name of the superuser who specified DB postgres

4. Start the database

Note: If you do not register as a system service, you need to start each time manually, otherwise pgadmin3 connection to the database failed

5. Register as Win7 system service

Pg_ctl register-n pgsql-d d:\\pgsql\data

To view a service that has already been registered: Win+r in the Popup Run box, enter: Services.msc, as follows:

NET start Pgsql startup service

To see if it starts: Enter tasklist at the command line

Netstat–an can view all IP connections to the local computer

net stop Pgsql service:

Uninstall Service: Also requires administrator privileges, two ways

1) pg_ctl Unregister–n pgsql

2) SC Delete Pgsql

6. Configure the PGADMIN3 client:

Directory is D:\2016\postgresql\bin\ pgAdmin3, double-click, configure

Initial state when server group below server is empty click

Logon Server information:

The user name is set to administrator at initial logon, otherwise:

7. Connection Database Success

How to download and configure Windows PostgreSQL database