9.3.2
Table Of Contents
- Using VMware vFabric Postgres
- Contents
- Preface
- VMware Customizations for PostgreSQL
- Installing vFabric Postgres
- vFabric Postgres Client Tools and Libraries
- Managing vFabric Postgres
- Migrate PostgreSQL Data from Earlier Versions Into vFabric Postgres 9.3
- Migrate PostgreSQL Data Into vFabric Postgres
- Restarting the vFabric Postgres Service
- Connection to a vFabric Postgres Database
- Accounts and Services
- Safeguarding Data
- About vFabric Postgres Replication
- Create a Replication User Account
- Create a Replica Server
- Promote a Replica Database to Primary Database
- Monitoring Replication Status
- Using Perl and Python Language Extensions
- Viewing Performance Statistics
- Troubleshooting Guidelines
- Using the Graphical User Interface
- Index
Option Description
DB_OWNER_PASS="password"
(Optional) This optional parameter lets you specify the DB_OWNER user's
password. If you do not specify a password, DB_OWNER user's password
is generated with a random string.
Encapsulate the password you specify in double quotes, which the system
discards.
The password is stored in %APPDATA%\postgresql\pgpass.conf where
%APPDATA% points to the Windows administrator's application data
directory (as defined by the APP_DATA environment variable) running
the vFabric Postgres MSI installer.
DB_NAME=name
(Optional) The name of the new database to create.
The database name you specify must be a properly formed SQL identifier.
SQL identifiers must begin with a letter (a-z, but also letters with diacritical
marks and non-Latin letters) or an underscore (_). Subsequent characters in
an identifier or key word can be letters, underscores, and digits (0-9).
Dollar signs ($) are not allowed in identifiers.
Example: Custom Installation
This example installs vFabric Postgres using the default directory locations for the data and log files. The
database owner name is demo_user, and the database name is demo_db.
The DB_NAME and DB_OWNER parameters are optional. If you supply both, the installer creates a new
database and database owner using the names you provide. If you omit one or both of these parameters, no
database or database owner are created, and the database server will only have the postgres system
database. You can create additional users and databases using PostgreSQL createdb and createuser
commands, or using the SQL CREATE DATABASE or CREATE USER commands.
NOTE You must type the msiexec command on a single line.
msiexec /i VMware-Postgres-9.3.2.0-0123456-x64-CIS.msi
PG_DATA_DIR="C:\ProgramData\VMware\Postgres\data"
PG_LOG_DIR="C:\ProgramData\VMware\Postgres\log" DB_OWNER=demo_user
DB_NAME=demo_db
Uninstall the vFabric Postgres Windows Service
You can uninstall the vFabric Postgres Windows service from a Windows physical host or virtual machine.
Prerequisites
You must have previously installed vFabric Postgres as a Windows service using the Microsoft Windows
Installer (MSI). See “Install vFabric Postgres as a Windows Service,” on page 15.
Procedure
1 Log in as a Windows system administrator.
2 Uninstall the program by selecting Start > Control Panel > Programs > Programs and Features.
3 Select the vFabric Postgres Windows service, and then click Uninstall.
The uninstall procedure stops and removes the vFabric Postgres Windows service and the vFabric Postgres
software binaries. Both the data directory and log file directory are left behind, letting you inspect or re-use
them. The default locations for the data and log file directories are C:\ProgramData\VMware\Postgres\data
and C:\ProgramData\VMware\Postgres\log.
Chapter 2 Installing vFabric Postgres
VMware, Inc. 17