-
Exec into Postgres pod
kubectl -n ef-external exec -it ef-postgresql-0 -- bash -
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 -
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" -
\connect "cisco_connector" -
ALTER TABLE jtapi_events ADD COLUMN IF NOT EXISTS connection_address VARCHAR(255); -
\q exit exit