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 Create a folder labeled pgdata, and assign it to the postgres user.
mkdir /var/vmware/vpostgres/9.3/pgdata
chmod 755 /var/vmware/vpostgres/9.3/pgdata
chown postgres /var/vmware/vpostgres/9.3/pgdata
4 Change to the postgres user.
su postgres
5 Initialize the database using the init command.
cd /opt/vmware/vpostgres/currect/bin
./initdb -D /var/vmware/vpostgres/9.3/pgdata
6 Start the database using either the pg_ctl command or the postgres command.
n
To start the database using the postgres command, use the following command syntax.
./postgres -D /var/vmware/vpostgres/9.3/pgdata
n
To start the database using the pg_ctl command, use the following command syntax.
./pg_ctl start -D /var/vmware/vpostgres/9.3/pgdata
7 You can now connect to the database as the postgres user using the psql command.
./psql -U postgres
8 (Optional) Create a database to test the installation.
This example creates the database test1.
postgres=#CREATE DATABASE test1;
CREATE DATABASE
9 If you want to you use the GUI, you can download a ZIP file that contains the vpgdbem.war file from the
vFabric Postgres download site and move the file to the webapps directory of your Tomcat server.
You can then use the vpgdbem URI to access the GUI. For example, if your Tomcat server is installed
for port 8080, you can access the GUI at http://ipaddress:8080/vpgdbem.
What to do next
You can set the passwords for the postgres operating system and database user. See “Passwords in vFabric
Postgres,” on page 8.
Install vFabric Postgres as a Windows Service
You can install vFabric Postgres using the Microsoft Windows Installer (MSI) on a Windows physical host,
or create a virtual machine using a supported Windows operating system.
The MSI installer lets you install the Windows 64-bit (x64) version of vFabric Postgres as a Windows service.
The supported operating systems are Windows 2008, 2008 R2, and Windows 2012.
You can run the MSI installer either by double-clicking the executable file on your Windows desktop, or by
running it from the command prompt and supplying custom installation parameters. If you choose to install
vFabric Postgres by double-clicking the executable file, the installation uses the default values for directory
paths, the database user name and password, and the database name.
A single vFabric Postgres database server (identified by a Windows service name) can serve multiple
databases. Each database is identified using a unique database name. By default, when you create a
vFabric Postgres database server instance, a system database labeled postgres is created. Do not use the
postgres system database to store your application's data. Instead, create additional databases for use with
your applications.
Chapter 2 Installing vFabric Postgres
VMware, Inc. 15