Deploying Containerized PostgreSQL Database

Installation of PostgreSQL database is not required for PostgreSQL database setup. The Dockerfile located inside fcdb directory inherits from library/postgres:9.6 which is an official image of PostgreSQL database. The same Dockerfile also creates a database schema necessary for TIBCO Product and Service Catalog. For deploying PostgreSQL, perform the following steps:

Procedure

  1. To create fcdb, ensure that the following values are entered in fcdb.json:
    • Kind: Deployment
    • App in matchLabels: fc (this value must be same as the value of the app in selector in fcdbservice.json)
    • Tier in matchLabels: PostgreSQL (this value must be same as the value of the app in selector in fcdbservice.json)
    • Image: Docker registry url of image with latest tag
    • Name in imagePullSecrets: Name of the registry credentials created to pull the images
  2. Run the following command to create fcdb.json: 
    $ kubectl create -f fcdb.json
  3. To create fcdbservice, ensure that the following values are entered in fcdbservice.json:
    • Kind: Service
    • Type: LoadBalancer
    • Name: tcp
    • Protocol: TCP
    • Port: 5432
    • targetPort: 5432
  4. Run the following command to create fcdbservice: 
    $ kubectl create -f fcdbservice.json