Installing PostgreSQL on Windows

Follow these steps to install PostgreSQL on the same Windows server that ArcSDE is (or will be) installed.

Note:

If you plan to install PostgreSQL using Remote Desktop, you must use the Windows mstsc.exe, and be sure to grant the postgres service account full permissions to the directory on the remote machine to which PostgreSQL is being installed.

Steps:

1. Log in to the computer where you will be installing the software as a user with administrative privileges.
2. Close all applications on your computer.
3. Access the ArcSDE installation files.
   • If you have a DVD, place it in the appropriate drive.
   • If you have an ISO image, use an ISO extractor to access the files.
4. Double-click the ESRI.exe to start it.
5. Choose the ArcSDE for PostgreSQL option on the ArcSDE installation dialog box.
6. The Installation dialog box gives you the option to install PostgreSQL and install ArcSDE. If you leave both checked, the PostgreSQL installation launches first.
   Note:

   The wizard detects if you already have PostgreSQL installed. If the existing PostgreSQL database cluster is an earlier, unsupported release, a message is returned telling you to upgrade PostgreSQL. To upgrade your PostgreSQL database cluster, create a backup of your database cluster, then execute the UPGRADE.bat script available on the ArcGIS Server installation media. If you have a problem running the UPGRADE.bat script, copy the entire Support folder to the local server and run the script.

   If you have a supported version of PostgreSQL installed, the installation wizard detects this, skips the PostgreSQL installation, then goes directly to the ArcSDE installation.

7. Click Next on the Welcome dialog box.
8. Read the PostgreSQL installation notes. When you have finished reading, click Next.
9. Choose the installation options you want from the Installation options dialog box.
   1. Click the drop-down next to National language support and click Will be installed on local hard drive.
   2. If you want to have the option to install additional PostgreSQL components, such as database drivers, Slony-I, PostGIS, or Ruby on Rails, click the drop-down list next to Application Stack Builder and click Will be installed on local hard drive.
10. Click Next.
11. Configure the PostgreSQL service.
    1. On the Service configuration dialog box, create or designate a nonadministrative Windows account to run the PostgreSQL service. This can be an existing Windows account, or you can let the wizard create one for you. If you have already created an account to use for this purpose, type the name of the account in the Account name text box and the password for the account in the Account password and Verify password text boxes. If you have not created an account, you can leave the default postgres name or type a new name in the Account name text box, then type a password in the Account password and Verify password text boxes, and the installation wizard will create the account for you.
    2. Leave Install as a service checked on the Service configuration dialog box.
12. Click Next.
13. Supply a password in accordance with the security policy of your operating system and organization.

    Depending on the password policy, you may receive a message indicating your password is weak. This dialog box gives you the opportunity to have the server assign a random password.

    • Click Yes if you want a random password assigned.
    • Click No to keep your weak password.
      Note:

      If you choose to keep your password, and you are installing on a Windows Server 2008 computer, the next step will fail, and the installation will terminate.

14. Initialize the database cluster.
    1. Leave the Initialize database cluster box on the Initialise database cluster dialog box checked.
    2. Assign a port number for connections by using the default number (5432) or typing another port number in the Port number text box.
       Note:

       If you use a service number other than the default, you must set the PGPORT environment variable to point to the port number you use.

    3. Set up the instance to accept network connections by checking Accept connections on all addresses, not just localhost.
    4. Choose the locale for your database cluster and the encoding for the server on which the database cluster resides and client machine using the corresponding drop-down menus on the Initialise database cluster dialog box.

       UTF-8 is recommended for the encoding to take advantage of Unicode capabilities; however, this is not required. The client encoding is detected as the encoding of the machine from which you are running the installation. Also, unless you need to specify a locale for your databases, it is recommended that you accept the C locale, because using other locales could slow the performance of string operations.

    5. Create a postgres super user account by typing a password for the super user in the Password text box and confirm it by typing the password in the Password (again) text box.
15. Click Next.
16. Enable PL/pgsql by accepting the defaults on the Enable procedural languages dialog box, then click Next.
17. Check the Adminpack and plDebugger contrib modules on the Enable contrib modules dialog box.
18. Click Next.
19. Click Next on the Ready to install dialog box.

    A progress bar displays. When the PostgreSQL installation is complete, the Installation complete dialog box appears.

20. Click Finish to exit the PostgreSQL installation wizard.