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
Table 1‑1. vFabric Postgres Users for OVF Deployment
User Name User Type
root operating system user
postgres operating system user
postgres database user
You can specify a single password for all three users during deployment of the OVA. If you did not specify
a password during deployment, you are prompted for a password when you access the virtual appliance
console for the first time.
NOTE Remote login for root operating system user is disabled. If you use SSH to log in you must do so as
the postgres operating system user.
For automated deployments, you can use ovftool --prop:Password=secret.
RPM Installation
During RPM installation, the installer creates the following users.
Table 1‑2. vFabric Postgres Users for RPM installation
User Name User Type
postgres operating system user
postgres database user
With RPM installation, no initial password is set for the postgres operating system user or the postgres
database user. The root user already exists before the RPM installation and its password is set using Linux
commands.
n
To set the postgres operating system user password, log in as root and use the passwd command to set a
new password.
passwd postgres
n
To set the postgres database user password, log in as the postgres operating system user and use the
alter command.
/opt/vmware/vpostgres/current/bin/psql -c "alter user postgres with password 'your-
password'"
Changing Passwords After Installation
After installation, you can change passwords as follows.
n
Use the /opt/aurora/sbin/set_password command to change the password for all three users.
n
Use the passwd command to change passwords individually for the system users.
n
Use the following command to change the password for the postgres database user.
/opt/vmware/vpostgres/current/bin/psql -c "alter user postgres with password 'your-
password'"
Chapter 1 VMware Customizations for PostgreSQL
VMware, Inc. 9