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