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.
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.
Postgres Pro application is registered with Windows Firewall anyway, so if you have not 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.
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.
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.
A special NT AUTHORITY\\NetworkService
account is used.
Installation directory path:
/D=path
Silent install:
/S
*.ini file with installation options:
/init=ini_file_name
You can add the following installation options to the [options] section of the INI file:
InstallDir — path where to install server
DataDir — path where to create default
database
Port — TCP/IP port to listen. Default: 5432.
SuperUser — name of the database user who
will have admin rights in the database
Password — password of the user
noExtConnections = 1 — don't allow external
connection
Coding = UNICODE — character encoding to
use in the database
Locale — locale to use in the database.
There can be several different locales for each encoding
Vcredist = 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
needoptimization = 0 — disable automatic
tuning of configuration parameters based on the available system resources.
datachecksums = 0 — disable data checksums
for the cluster.