5.13.0 5.12.0 5.11.0 5.10.0 5.9.0 5.8.0 5.7.0 5.6.0 5.5.0 5.4.0 5.3.0 5.2.0 5.1.0 5.0 4.10 4.9 4.8 4.7 4.6 4.5.3 4.5.2 4.5.1 4.5 4.4 4.3
5.13.0 5.12.0 5.11.0 5.10.0 5.9.0 5.8.0 5.7.0 5.6.0 5.5.0 5.4.0 5.3.0 5.2.0 5.1.0 5.0 4.10 4.9 4.8 4.7 4.6 4.5.3 4.5.2 4.5.1 4.5 4.4 4.3

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