16.2. Installing Postgres Pro on Windows
For Windows systems, Postgres Pro provides a binary self-extracting interactive installer that installs all the components at once. The installer also provides the options to create the default database.
16.2.1. External Connections and Windows Firewall
By default, Postgres Pro server is listening for connections from the localhost only. To allow external connections to Postgres Pro server, select the "Allow external connections" checkbox to add the appropriate parameter into the postgresql.conf file, add a line into the pg_pba.conf file, and create a Windows Firewall rule.
Note
Postgres Pro application is registered with Windows firewal anyway, so if you haven't enabled external connection during installation, and decide to do it later, you only have to open Windows Firewall configuration in the Control Panel, find the Postgres Pro server here, and allow it to accept connections.
16.2.2. Supported Operating Systems
Postgres Pro provides two versions of Windows distribution:
distribution for Windows 7, Windows Server 2008 R2 or higher
compatibility distribution built with Windows SDK 7.1, which supports Windows XP and Windows Server 2003 Do not use the compatibility version on newer versions of Windows.
16.2.3. Procedural Languages
The procedural languages PL/Perl, PL/Python are included in this distribution of Postgres Pro. The server has been built using the LanguagePack community distributions of those language interpreters. To use any of the these languages from within Postgres Pro, download and install the appropriate interpreters and ensure they are included in the PATH variable under which the database server will be started.
The current version of PL/Python is dynamically linked with Python shared library in the LanguagePack installers. Some distributions of Python interpreters (including ActivePython) on Windows do not include a dynamic library of Python. Such interpreters would no longer be functional with PL/Python. You are recommended to use LanguagePack installers for PL/Perl and PL/Python instead.
16.2.4. Windows Service Account
A special NT AUTHORITY\\NetworkService account is used.
16.2.5. Command-Line Options
Installation directory path:
/D=path
Silent install:
/S
*.ini file with instalation options:
/init=ini_file_name
16.2.6. INI File Format
In the section [options] can be these options:
InstallDir— path where to install serverDataDir— path where to create default databasePort— TCP/IP port to listen. Default: 5432.SuperUser— name of the database user who will have admin rights in the databasePassword— password of the usernoExtConnections = 1— don't allow external connectionCoding = UNICODE— character encoding to use in the databaseLocale— locale to use in the database. There can be several different locales for each encodingVcredist = no— do not install Visual C redistributable libraries (use it only if these libraries are already installed on your system)envvar = 1— set up environment variables helpful for Postgres Pro:PGDATA,PGDATABASE,PGUSER,PGPORT,PGLOCALEDIR