Note that the download is a binary sedan, not with Windows Installer.
Http://www.enterprisedb.com/products-services-training/pgbindownload
x86 download Http://get.enterprisedb.com/postgresql/postgresql-9.2.4-1-windows-binaries.zip
x64 Download Http://get.enterprisedb.com/postgresql/postgresql-9.2.4-1-windows-x64-binaries.zip
Before performing the following steps, tentatively assume the following:
PostgreSQL to be fitted in D:\postgresql
The database is intended to be stored in D:\postgresql\data
First download Postgresql-9.2.4-1-windows-x64-binaries.zip the latest version to be used, the following steps to achieve the manual installation of PostgreSQL, initialize the database, the PostgreSQL registration as a service.
1, Postgresql.zip decompression to D:\postgresql, create a data directory;
2. Set environment variables, edit batch files configure environment variables. VBS (PERMANENT)
A) The contents are as follows
On Error Resume Next
set Sysenv=createobject ("Wscript.Shell"). Environment ("system") ' Array object
Path = CreateObject (' Scripting.FileSystemObject ') for system environment variables. GetFolder ("."). Path
' Add variable
sysenv ("pghome") = "D:\pgsql"
sysenv ("PGHOST") = "localhost"
sysenv ("Path") =sysenv (" Pghome ") +" \ Bin; " +sysenv ("Path")
sysenv ("Pglib") =sysenv ("pghome") + "\lib"
sysenv ("Pgdata") =sysenv ("pghome") + "\data"
WScript.Echo "PostgreSQL environment variable installation success!" You don't need to restart your computer! "
b) implemented as follows:
3, in the blank place hold shift Click the right mouse button, new open a CMD window, and CD to D:\postgresql\bin;
4. Initialize and create the database (once)
initdb.exe-d D:\postgresql\data-E UTF-8--locale=chs-u postgres-w
-D: Specifies the storage directory for the database cluster E:\pgsql\data
-E: Specifies the user name of the superuser for DB Postgres
--locale: About regional Settings (Chinese-simplified-china)
-u: Default encoding format CHS
-W: Tips for assigning passwords to super users
As follows:
4. Start the database
Note: If you are not registered as a system service, you need to manually start each time, otherwise the PGADMIN3 connection database fails
pg_ctl-d d:\postgresql-l logfile Start
The display is as follows:
After startup, generate a logfile file in the home directory where the database is installed: D:\postgresql\logfile
5. Registration for WIN8 system services
Note: Administrator privileges are required to
Pg_ctl register-n postgresql-d D:\postgresql\data
View Registered Services: Win+r in the pop-up Run box, enter: Services.msc, as follows:
net start PostgreSQL to see if it starts: command-line Input tasklist
Netstat–an can view all IP uninstall services that establish a connection to the local computer: Administrator privileges are also required, two ways
1) pg_ctl unregister–n PostgreSQL (WIN8)
2 SC Delete PostgreSQL (PostgreSQL)
6. Configure the PGADMIN3 client
Directory for D:\postgresql\bin\ pgAdmin3, double-click, configure
7. Connection Database Successful
How do I get PostgreSQL to support remote logins?
Only need to configure on the server side
Modify two files:
Postgresql.conf
Pg_hba.conf
-----------------
For example, the DB server IP in the environment is 10.10.3.5,
The IP of the client is 10.10.3.5
Add in postgresql.conf file:
listen_addresses = ' * '
Add in pg_hba.conf file:
Host All 10.10.3.1/24 Trust
24 indicates that the mask is 255.255.255.0, so it is open for all IP on this subnet.
You can visit 10.10.3.5 on the 10.10.3.5.
Perform after completion
C:\windows\system32>net Stop PostgreSQL
C:\windows\system32>net Start PostgreSQL