To create a place to learn and understand SchemaHero, let's deploy a test instance of Postgres. This will run in the local cluster, and can be deleted when the tutorial is completed. If you have a test Postgres server already, feel free to skip this step and connect SchemaHero to that database.
There's a Kubernetes YAML for postgres in this repo. Let's deploy that and we will get a StatefulSet named
postgresql with a 1 GB PersistentVolumeClaim.
kubectl apply -f https://raw.githubusercontent.com/schemahero/schemahero/master/config/dev/database/postgres.yaml
After deploying this, you can connect to your postgres database from the CLI using:
kubectl exec -it postgresql-0 psql -- -U testuser -d testdb
When promoted, the password for “testuser” is “password”.
If you'd prefer to connect to this database using a local GUI such as SequelPro, run:
kubectl port-forward svc/postgresl 5432:5432
And then point your app to 127.0.0.1:5432 with the user “testuser”, database “testdb” and password “password”.
Explore this database. Notice that it's empty.