TimescaleDB

Access the TimescaleDB instance in STFC

  • To access the timescaleDB instance in STFC, please check latest k8s-test job(line 57) to get the latest external IP and port.

  • The external IP for mid: 10.200.10.143/timescaledb.ska-eda-mid-db.svc.cluster.local:5432 are for current deployment, here 5432 is port. If it is redeployed, make sure to update it with latest external IP.

  • The external IP for low : 10.200.12.14 / timescaledb.ska-eda-low-db.svc.cluster.local:5432 are for current deployment, here 5432 is port. If it is redeployed, make sure to update it with latest external IP.

  • Install postgres client on user machine :Follow the steps in the given : https://www.postgresql.org/download/linux/ubuntu/ for installation.

  • Make sure the user’s machine is connected to SFTC vpn.

  • Enter below command to access the TimescaleDB.

    psql -U admin -h <external-ip> -p <port> -d <db-name>

  • Where default db-name is postgres and branch specific db-name can be

    ska_archiver_<branch_name> ,for eg : ska_archiver_hm_72.

  • Enter the password to access the DB.