Creating a PostgreSQL 9.2 on RHEL 6.2 service offering

This topic describes the tasks that you must perform in BMC Cloud Lifecycle Management to create the service offering that the end user could then use to provision the application infrastructure (for example, an OS and an application package). It includes the following topics:

• • To create the service and the service offering
  • To make the provisioning request
  • To validate the provisioned components
  • Where to go next

To create the service and the service offering

In the BMC Cloud Lifecycle Management Administrator console, you must add a service and a service offering.

For PostgreSQL 9.2 Contact-Pack, you can create a service and service offering based on the available deployment model. The PostgreSQL 9.2 Contact-Pack supports single-tier service deployment model. In single-tier deployment model, PostgreSQL 9.2 is installed and configured on single server instance.

To create a service

To create a service offering

To make the provisioning request

To make provisioning request for Couchbase cluster or node:

1. Access Workspaces > Service Instances to display the Service Instances workspace, and click New Service Request.
   
   
2. In the New Service Request dialog box, click the server provisioning service you want to display the Submit Request dialog box.
3. Enter the data in the required fields to complete the request for an instance of the service request. You can click Next to review the details.
   
4. Click Submit.
5. The request is added to the Pending Activity list in the Service Instances window.

The request status is displayed in the Pending Activity list of the Service Instances window. You can double-click the service request to see detailed information.

For more detailed procedures, see Requesting cloud services.

To validate the provisioned components

After provisioning the PostgreSQL 9.2 Contact-Pack, you can validate PostgreSQL 9.2 components setup in your environment.

Component name	How to verify	Results
To verify PostgreSQL port	To verify PostgreSQL port number, run the following command: netstat -tnlp | grep 5432	This command displays the port number on which PostgreSQL is running.
To list PostgreSQL databases	To list PostgreSQL databases, run the following command:  psql -l -U postgres	This command displays a list of PostgreSQL databases.

Where to go next

After you have created the service offering, the cloud end user can request a service offering from the My Cloud Services console. To view a list of tasks that the cloud end user can perform to manage your cloud services, see Managing cloud services in the BMC Cloud Lifecycle Management online technical documentation.