Postgres uses SQL language to store and manage databases on the system. This procedure describes how to view and obtain helpful information about system databases, as well as the types of data being stored.
This procedure requires administrative privileges.
-
Log in to the Postgres container.
ncn-w001# kubectl -n services exec -it cray-smd-postgres-0 -- bash Defaulting container name to postgres. Use 'kubectl describe pod/cray-smd-postgres-0 -n services' to see all of the containers in this pod. ____ _ _ / ___| _ __ (_) | ___ \___ \| '_ \| | |/ _ \ ___) | |_) | | | (_) | |____/| .__/|_|_|\___/ |_| This container is managed by runit, when stopping/starting services use sv Examples: sv stop cron sv restart patroni Current status: (sv status /etc/service/*) run: /etc/service/cron: (pid 26) 487273s run: /etc/service/patroni: (pid 24) 487273s run: /etc/service/pgqd: (pid 25) 487273s
-
Log in as the postgres user.
root@cray-smd-postgres-0:/home/postgres# psql -U postgres psql (12.2 (Ubuntu 12.2-1.pgdg18.04+1), server 11.7 (Ubuntu 11.7-1.pgdg18.04+1)) Type "help" for help. postgres=#
-
List the existing databases.
postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ------------+-----------------+----------+-------------+-------------+----------------------- hmsds | hmsdsuser | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | service_db | service_account | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (5 rows)
-
Establish a connection to the desired database.
In the example below, the
hmsds
database is used.postgres=# \c hmsds psql (12.2 (Ubuntu 12.2-1.pgdg18.04+1), server 11.7 (Ubuntu 11.7-1.pgdg18.04+1)) You are now connected to database "hmsds" as user "postgres". hmsds=#
-
List the data types that are in the database being viewed.
hmsds-# \dt List of relations Schema | Name | Type | Owner --------+-------------------------+-------+----------- public | comp_endpoints | table | hmsdsuser public | comp_eth_interfaces | table | hmsdsuser public | component_group_members | table | hmsdsuser public | component_groups | table | hmsdsuser public | component_lock_members | table | hmsdsuser public | component_locks | table | hmsdsuser public | components | table | hmsdsuser public | discovery_status | table | hmsdsuser public | hwinv_by_fru | table | hmsdsuser public | hwinv_by_loc | table | hmsdsuser public | hwinv_hist | table | hmsdsuser public | job_state_rf_poll | table | hmsdsuser public | job_sync | table | hmsdsuser public | node_nid_mapping | table | hmsdsuser public | power_mapping | table | hmsdsuser public | rf_endpoints | table | hmsdsuser public | schema_migrations | table | hmsdsuser public | scn_subscriptions | table | hmsdsuser public | service_endpoints | table | hmsdsuser public | system | table | hmsdsuser (20 rows)