PostgreSQL

# Part I – Database export
# If you need to transfer data from an existing instance, use pg_dump.
# You may skip down to "Part II" if you set up a new database.

# (on existing DB node)
# Please note that it's extremely important to use "--no-owner" flag, as
# on a new instance role name would likely be different.
pg_dump --no-owner myawesomedb > myawesomedb.sql

# Part II – Creating a database

# Hop onto the database node
tsh ssh root@ru-lnsk-database

# Create a new user-database pair.
# Copy the resulting PostgreSQL URI connection string.
./manage-db create my_awesome_app

# If YOU HAVE a database backup – copy it on database instance,
# then apply to a clean database
./manage-db import-dump my_awesome_app dump.sql

# Part III – Connecting to the database

# First, you need to obtain a B4CKSP4CE Root CA, as it's used
# to sign PostgreSQL server certificate.
# More info at https://ca.bksp.in

# (on your app node)
curl -fSsl https://ca.bksp.in/root/bksp-root.crt > B4CKSP4CE_Root_CA.crt

# Now you can connect using either full connection string from the Part II,
# or manually extract the neccessary fields from it.

# Prisma ORM is known to treat DATABASE_URL connection string well.
# You may put the one you've got on Part II, and use as is in environment
# variable. Don't forget to mount B4CKSP4CE Root CA file into container, and
# adjust connection string's sslrootcert path if neccessary