Install PostgreSQL on Windows

To install PostgreSQL on Windows:

1. Download and run the Windows PostgreSQL one click installer.
2. Install PostgreSQL as a Windows Service.
3. Keep track of the PostgreSQL Windows Service account name and password. LabKey Server doesn't really care what this password is set to, but we need to ask for it so that we can pass it along to the PostgreSQL installer.
4. Keep track of the database superuser name and password. You'll need these to configure LabKey Server. LabKey Server uses this password to authenticate itself to PostgreSQL.
5. Select the PL/pgsql procedural language for installation when prompted by the installer.
6. We recommend that you install the graphical tool pgAdminIII for easy database administration. Leave the default settings as they are on the "Installation Options" page to include pgAdminIII.
7. If you have chosen to install pgAdminIII, enable the Adminpack contrib module when prompted by the installer.
8. Please read the notes below to forestall any difficulties with the PostgreSQL installation.

• You can only install one instance of PostgreSQL on your computer. If you already have PostgreSQL installed, LabKey Server can use that installed instance, provided the version is supported.
• You may need to disable your antivirus or firewall software before installing PostgreSQL, as the PostgreSQL installer conflicts with some antivirus or firewall software programs. (see http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows for more information).
• On Windows you may need to remove references to Cygwin from your Windows system path before installing PostgreSQL (see http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows for more information).
• If you uninstall and reinstall PostgreSQL, you may need to manually delete the data directory in order to reinstall. By default the data directory on a Windows computer is C:\Program Files\PostgreSQL\8.x\data.
• On Vista, you may need to run 'cmd.exe' as administrator and run the installer .msi from the command line.
• See also: Notes on Installing PostgreSQL on All Platforms
• After installation, you may find it helpful to tune PostgreSQL for performance.