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 Restart the service.
$service vpostgres_mon start
Stop and Start the vFabric Postgres Service for RPM Installations
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.
If you installed the vFabric Postgres service using RPM files, the service is running within your virtual
machine. In contrast to the virtual appliance, VMware HA is not integrated with the service and is not
affected.
For many configuration options, a configuration file reload with SIGHUP or pg_ctl reload is sufficient.
Procedure
1 Change the configuration.
2 Stop the service.
$service vpostgres stop
3 Restart the service.
$service vpostgres start
Connection to a vFabric Postgres Database
Connecting to a vFabric Postgres database is the same as connecting to a standard PostgreSQL database.
Accounts and Services
When you deploy the vFabric Postgres DBMS, two users are created. When the vFabric Postgres server is
running, it includes services that accept remote connections.
Accounts Created During OVA Deployment
When you deploy the vFabric Postgres OVA template, the following users are created.
Table 4‑1. vFabric Postgres Users Created During OVA Deployment
User Name User Type
root operating system user The root user can log into the appliance from the
guest console using the same random password as
the postgres user. Remote ssh logins are disabled
for root. Database access is also disabled for root.
postgres operating system user The postgres operating system user can start the
database instance and act as the super user. This
user can log in to the console and into a shell.
postgres database user The postgres user is a database administrator
account. This user can log into the appliance from
the guest console, log in remotely using ssh, or
connect to the database service on port 5432. The
OVF deployment wizard prompts you to spedify
the password for all three users. Use
the /opt/aurora/sbin/set_password command
to change the password for the postgres user.
Chapter 4 Managing vFabric Postgres
VMware, Inc. 27