Note that the download is a binary version, not a 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, make the following assumptions:
PostgreSQL to be installed in d: \ postgresql
The database will be stored in d: \ postgresql \ data later.
Download the latest version of postgresql-9.2.4-1-windows-x64-binaries.zip. Follow these steps to manually install PostgreSQL, initialize the database, and register PostgreSQL as a service.
1. Unzip postgresql.zip to d: \ postgresql and create a data directory;
2. Set the environment variable and edit the environment variable of the batch file configuration. vbs (valid permanently)
A) the content is as follows:
On error resume nextset sysenv = CreateObject ("WScript. shell "). environment ("system") 'array object of the system Environment variable Path = CreateObject ("Scripting. fileSystemObject "). 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 successful! No need to restart the computer! "
B) perform the following:
3. Right-click shift in the blank space, open a new cmd window, and cd to d: \ postgresql \ bin;
4. initialize and create a database (once)
Initdb.exe-D d: \ postgresql \ data-E UTF-8 -- locale = chs-U postgres-W
-D: Specifies the storage directory of the Database Cluster E: \ pgsql \ data
-E: Specify the database superuser username postgres
-- Locale: About region settings (chinese-simplified-china)
-U: the default encoding format is chs.
-W: Prompt for specifying a password for a Super User
As follows:
4. Start the database
Note: If you are not registered as a system service, you must manually start the service each time. Otherwise, pgadmin3 fails to connect to the database.
Pg_ctl-D d: \ postgresql-l logfile start
Shown as follows:
After it is started, A logfile file is generated under the main directory installed in the database: D: \ postgresql \ logfile
5. Register as a win8 System Service
Note: Only Administrators are required.
Pg_ctl register-N PostgreSQL-D: \ postgresql \ data
View the registered service: win + R in the pop-up dialog box, enter services. msc, as shown below:
Net start PostgreSQL to check whether the task is started: Enter tasklist in the command line
Netstat-an allows you to view all IP addresses that are connected to the local computer and uninstall the service. You also need administrator permissions.
1) pg_ctl unregister-N PostgreSQL (win8)
2) SC delete PostgreSQL (PostgreSQL)
6. Configure the pgAdmin3 Client
Directory: D: \ postgresql \ bin \ pgAdmin3, double-click to configure
7. Database Connection successful
How can postgresql support remote login?
You only need to configure
Modify two files:
Postgresql. conf
Pg_mirror.conf
-----------------
For example, the ip address of the db server in the environment is 10.10.3.5,
The Client ip address is 10.10.3.5.
Add the following in the postgresql. conf file:
Listen_addresses = '*'
Add:
Host all 10.10.3.1/24 trust
24 indicates that the mask is 255.255.255.0, so it indicates that all IP addresses in this subnet are open.
You can access 10.10.3.5 on 10.10.3.5.
Run
C: \ Windows \ System32> net stop PostgreSQL
C: \ Windows \ System32> net start PostgreSQL