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
vFabric Postgres performance with a slight increase in disk space and
memory requirements. The result is that users of an embedded
vFabric Postgres database can more easily tune the database for their
workload.
If you are using vFabric Postgres, and you use the RPM installation, these
changes to default values are not made.
Separate XLog Files and
Archive Files
Files of pg_xlog are stored on a different partition than that used by the main
database to better leverage I/O activity on the server, and provide strict
control over the storage space allowed for WAL files. This strategy is used as
well for the archive to cover cases where a partition disk failure would
prevent the reuse of archived WAL files for recovery. WAL archiving is
enabled on a given node when a standby node is enabled using the
replication scripts that connect to this node.
Replication Scripts
A set of scripts that simplify the management of replication between
vFabric Postgres nodes: slave creation, node promotion, and replication
monitoring. The scripts are located in the
folder /opt/vmware/vpostgres/current/scripts.
PGDATA Environment
Variable
The virtual appliance provides the PGDATA environment variable, which
specifies the directory to use for data storage. The value is set
to /var/vmware/vpostgres/current/pgdata.
Deploying vFabric Postgres
You can deploy a vFabric Postgres DBMS as a virtual appliance (OVA file) or by using RPM packages.
n
You can deploy the virtual appliance to create a virtual machine with the operating system (SLES 11, SP
2 64-bit Linux), a vFabric Postgres server, and a vFabric Postgres client preinstalled. The appliance
version of the vFabric Postgres database includes VMware virtualization technology.
n
You can use RPM to deploy vFabric Postgres. Use RPM installation with a physical host, or create a
virtual machine and install one of the supported operating system that are listed on the datasheet. Use -
ivh commands to install the RPMs. You can use this method to install the vFabric Postgres server and
client software.
n
You can use a Microsoft Windows Installer (MSI) to install vFabric Postgres on a Windows physical
host, or create a virtual machine using a supported Windows operating system. The software is
installed as a Windows service.
Passwords in vFabric Postgres
You specify the passwords for vFabric Postgres users during deployment, and can change passwords for
each user individually at a later time.
Passwords differ slightly depending on whether you deploy the OVF or perform an RPM installation.
OVA Deployment
After deployment of a vFabric Postgres OVA, three users are defined.
Using VMware vFabric Postgres
8 VMware, Inc.