Considerations for installing the "Go" PostgreSQL database on Windows Server 2008

Windows Server 2008 differs from the normal version of Windows in that it has more restrictive file/directory control permissions. PostgreSQL database is also a "Unix/linux service" program design, also has its own permissions rules, therefore, PostgreSQL installed on Windows Server 2008 some attention.

There are some differences between Windows Server 2008 and normal Windows XP: For ordinary users, except for sensitive system files/directories that are unreadable, other directories are read-only and cannot be written by default. Even if the current logged on user is an administrator user, many times write files will also pop up a dialog box, confirm that your administrator action, reduce the virus, Trojan horse program to change the file may be.

The PostgreSQL database follows the usual rules for running the Unix/linux Service program: Run system services with a user account with minimal privileges. This way, even if the account is cracked, it does not pose much risk.

Gossip less, directly to analyze the installation steps.

First, create a new database data storage directory, such as C:\db_data, right click on the folder, select "Properties", "Security", "edit", "Users", the "Full Control" line of "Allow" selected. Confirm the Save.

This step is due to the need for administrator privileges to install the PostgreSQL database, but if you use the database data directory created by the administrator during installation, such as C:\app\PostgreSQL\9.0\data, the database runtime user account Postgres ( Least-Privileged user account) does not write files to this data directory. The last database initialization of the installation process fails and the PostgreSQL database cannot be started.

You can avoid these problems by creating a directory that is fully controlled by an ordinary user (users) in advance.

Second, right click on the PostgreSQL database installer and select "Run as Administrator". This step is well understood, the installer will create the Windows service, ordinary users can not do this.

Third, during the installation process, "Data Directory" is selected as the first step to create the directory.

Four, during the installation process, the Locale is selected "Chinese (Simplified), Singapore". This is important. If you are installing PostgreSQL on a normal Windows XP or Windows 7, use the default "defaults". However, to install on Windows Server 2008, you must select "Chinese (Simplified), Singapore". Otherwise, in SQL with order by, the Chinese in the data cannot be sorted by pinyin.

The installation will end with a cluster (cluster) initialization failure warning, which can be ignored.

Five, after installation, create a new database,

Character sorting is selected Chinese (Simplified), Singapore.
Character classification to be selected Chinese (Simplified), Singapore.

Considerations for installing the "Go" PostgreSQL database on Windows Server 2008