Cisco Connector DB migration:

  1. Exec into Posgres pod

    kubectl -n ef-external exec -it ef-postgresql-0 -- bash
    
  2. Execute the environment setup for ef-postgresql-0 ( Only needed when the 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 password "Expertflow123" when asked
    
  4. \connect "cisco_connector"
    
  5. Run following queries one by one:
    
    ALTER TABLE call_legs ADD COLUMN from_extension VARCHAR(255);
    ALTER TABLE call_legs ADD COLUMN to_extension VARCHAR(255);
    
  6. \q
    exit
    exit