Slide 7
Slide 7 text
動作確認
Zalando PostgreSQL Operator
7
2023-10-12 01:06:21 ⌚ nnaka2992-Dev in ~/Dev/gcloud/nnaka2992-kube-poc/manifests
○ → kubectl get pods
NAME READY STATUS RESTARTS AGE
nnaka2992-performance-comparison-cluster-0 1/1 Running 0 176m
postgres-operator-77f6d658c-wwrc6 1/1 Running 0 14h
postgres-operator-ui-7bf9676b84-gb7fh 1/1 Running 0 14h
# ここより下はProxyサーバ
$ export PGPASSWORD=$(kubectl get secret test.nnaka2992-performance-comparison-cluster.credentials.postgresql.acid.zalan.do -o 'jsonpath={.data.password}' | base64 -d)
$ host=$(kubectl get node -ojson | jq -r '.items[0].status.addresses[0].address')
$ port=$(kubectl get svc nnaka2992-performance-comparison-cluster -ojson | jq -r '.spec.ports[0].nodePort')
$ export PGSSLMODE=require
$ psql -U test -h $host -p $port
psql -U test -h $host -p $port
psql (15.4 (Debian 15.4-2.pgdg110+1), server 15.2 (Ubuntu 15.2-1.pgdg22.04+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.
test=> select schemaname as schema, viewname as name, 'view' as type from pg_views limit 3;
schema | name | type
----------------+-------------------------+------
public | pg_stat_statements_info | view
public | pg_stat_statements | view
public | pg_stat_kcache_detail | view