9.3.2

Contents
Preface 5
1
VMware Customizations for PostgreSQL 7
vFabric Postgres Virtual Appliance Enhancements 7
Deploying vFabric Postgres 8
Passwords in vFabric Postgres 8
2
Installing vFabric Postgres 11
Installation Overview 11
System Requirements 12
Deploy the OVA File 13
Install vFabric Postgres Using RPM Files 14
Install vFabric Postgres as a Windows Service 15
Uninstall the vFabric Postgres Windows Service 17
Install vFabric Postgres on vCloud Hybrid Service 18
3
vFabric Postgres Client Tools and Libraries 19
Overview of Tools and Libraries 19
Client Tool Packages and Drivers 20
Install the Client Tools Package 21
Add an x86 vFabric Postgres ODBC Data Source on Windows 22
Relink Your Application with vFabric Postgres libpq 22
4
Managing vFabric Postgres 25
Migrate PostgreSQL Data from Earlier Versions Into vFabric Postgres 9.3 25
Migrate PostgreSQL Data Into vFabric Postgres 26
Restarting the vFabric Postgres Service 26
Connection to a vFabric Postgres Database 27
Accounts and Services 27
Safeguarding Data 28
About vFabric Postgres Replication 31
Create a Replication User Account 32
Create a Replica Server 33
Promote a Replica Database to Primary Database 34
Monitoring Replication Status 34
Using Perl and Python Language Extensions 35
Viewing Performance Statistics 36
Troubleshooting Guidelines 38
5
Using the Graphical User Interface 39
Deploy the Graphical User Interface 39
VMware, Inc.
3