9.3.2

Managing vFabric Postgres 4
After you have installed the vFabric Postgres DBMS and the client tools, you can perform a variety of
management tasks.
This chapter includes the following topics:
n
“Migrate PostgreSQL Data from Earlier Versions Into vFabric Postgres 9.3,” on page 25
n
“Migrate PostgreSQL Data Into vFabric Postgres,” on page 26
n
“Restarting the vFabric Postgres Service,” on page 26
n
“Connection to a vFabric Postgres Database,” on page 27
n
“Accounts and Services,” on page 27
n
“Safeguarding Data,” on page 28
n
“About vFabric Postgres Replication,” on page 31
n
“Create a Replication User Account,” on page 32
n
“Create a Replica Server,” on page 33
n
“Promote a Replica Database to Primary Database,” on page 34
n
“Monitoring Replication Status,” on page 34
n
“Using Perl and Python Language Extensions,” on page 35
n
“Viewing Performance Statistics,” on page 36
n
“Troubleshooting Guidelines,” on page 38
Migrate PostgreSQL Data from Earlier Versions Into vFabric Postgres
9.3
If you want to import PostgreSQL data or vFabric Postges data from an earlier version, such as PostgreSQL
9.1 or vFabric Postgres 9.2, into vFabric Postgres 9.3, you can use a backup and restore process.
Procedure
1 Log in to the vFabric Postgres host.
2 Back up the existing database.
/opt/vmware/vpostgres/current/bin/pg_dumpall -c -h
ip_address_of_existing_db -U postgres -l postgres
VMware, Inc.
25