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
Services that Accept Remote Connections
The following vFabric Postgres services accept remote connections to the virtual appliance by default.
Table 4‑2. vFabric Postgres Services that Accept Remote Commections
Service Port
Postgres service 5432
SSH service 22
VAMI (Virtual Appliance Management Infrastructure)
Web Management UI. You can connect to port 5480 via
https to update or reconfigure the appliance.
5480
VAMI SFCB broker 5488 and 5489
GUI HTTPS service 5432
GUI HTTP service, which redirects to HTTPS 8080
If you are performing the RPM installation, only port 5432 is relevant.
Safeguarding Data
You create and manage data backups and recover databases using PostgreSQL Recovery Manager.
n
About Safeguarding Data on page 28
Taking regular backups of your database is essential to safeguarding your data. vFabric Postgres uses
PostgresSQL Recovery Manager, pg_rman, to perform backup and recovery of your database. You can
back up your database to capture changes, preserve the database, and enable recovery, letting you
restore data after a failure. You can also restore the database to its state at a particular point in time
and replay changes to troubleshoot a problem.
n
Backup Types on page 29
You manage backups and recover data using vFabric Postgres full backups, incremental backups, and
archive recovery.
n
Schedule Database Backups on page 31
You can schedule automated backups of your vFabric Postgres databases to protect your data.
n
Disable Database Backups on page 31
vFabric Postgres performs database backups using the pg_rman utility. To temporarily halt or
otherwise stop backups you disable database backups using the crontab utility.
About Safeguarding Data
Taking regular backups of your database is essential to safeguarding your data. vFabric Postgres uses
PostgresSQL Recovery Manager, pg_rman, to perform backup and recovery of your database. You can back
up your database to capture changes, preserve the database, and enable recovery, letting you restore data
after a failure. You can also restore the database to its state at a particular point in time and replay changes
to troubleshoot a problem.
vFabric Postgres provides the following features for safeguarding data.
n
Backup of databases including tablespaces.
n
Recovery of databases from full backups and incremental backups.
n
Incremental backup and compression of backup files to optimize disk space consumption.
n
Manages backup generations and can display a catalog of previous backups.
Using VMware vFabric Postgres
28 VMware, Inc.