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:14 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