Cisco Connector DB migration

  1. Exec into Postgres pod

    kubectl -n ef-external exec -it ef-postgresql-0 -- bash
    
  2. Execute the environment setup for ef-postgresql-0 ( Only needed when PostgreSQL is running in non-HA mode, like no pgpool and multiple replicas of PostgreSQL are running )

    /opt/bitnami/scripts/postgresql/entrypoint.sh /bin/bash
    
  3. Log into Postgres using the following command

    psql --host ef-postgresql -U sa postgres -p 5432
    
    Enter the password for the sa user, default password is "Expertflow123"
    
  4. \connect "cisco_connector"
    
  5. ALTER TABLE jtapi_events ADD COLUMN IF NOT EXISTS connection_address VARCHAR(255);
    
  6. \q
    exit
    exit