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
3 Restore the database on vFabric Postgres 9.3.
/opt/vmware/vpostgres/current/bin/psql -f
/var/vmware/vpostgres/current/mydb-backup
4 Vacuum the database after restore to make sure there is no error.
/opt/vmware/vpostgres/current/bin/vacuumdb -a -z -U postgres
Migrate PostgreSQL Data Into vFabric Postgres
You can migrate an existing PostgreSQL PGDATA directory that is using the current PostgreSQL version to
vFabric Postgres by stopping the service, archiving the data, and copying the archived file.
Migrating PostgreSQL data from an earlier version of PostgreSQL requires a different process. See “Migrate
PostgreSQL Data from Earlier Versions Into vFabric Postgres 9.3,” on page 25.
As part of the migration process, you stop and start the vFabric Postgres service. See “Stop and Start the
vFabric Postgres Service on the Virtual Appliance,” on page 26.
Procedure
1 Stop the vFabric Postgres service
2 Archive the existing PGDATA directory using any archiving tool.
3 Copy the PGDATA archive to the vFabric Postgres.
4 Unarchive and replace the existing PGDATA directory, /var/vmware/vpostgres/current/pgdata.
5 Start the vFabric Postgres service.
Restarting the vFabric Postgres Service
You can stop and start the vFabric Postgres service on the virtual appliance or for an RPM installation.
Restarting the service might be required if you change the configuration.
n
Stop and Start the vFabric Postgres Service on the Virtual Appliance on page 26
Stop and start the service on the virtual appliance if you deployed the OVF template and you want to
change the database configuration.
n
Stop and Start the vFabric Postgres Service for RPM Installations on page 27
If you change the database configuration of your RPM installation, you can perform a configuration
file reload or you can stop and start the vFabric Postgres service.
Stop and Start the vFabric Postgres Service on the Virtual Appliance
Stop and start the service on the virtual appliance if you deployed the OVF template and you want to
change the database configuration.
If you deployed the vFabric Postgres OVF template, use the following commands to stop and then restart
the service. For the appliance service, these commands also stop and start the VMware HA (high
availability) monitor process that makes sure the database process is up and running.
Procedure
1 Change the configuration.
2 Stop the service.
$service vpostgres_mon stop
Using VMware vFabric Postgres
26 VMware, Inc.