Notizen

user

password

schema

Create DB on dokku with given files

scp demo-flights.sql root@123.22.23.23:/root/demo-flights.sql

ssh root@123.22.23.23

# on dokku
mkdir flights
mv demo-flights.sql flights/demo-flights.sql

dokku postgres:create flights-db
docker cp flights/ $(dokku postgres:info flights-db --id):/home/flights

dokku postgres:enter flights-db

# inside postgres container "flights-db"
cd /home/flights
psql -f demo-small.sql -U postgres

Export Database (plain text)

pg_dump --host=<host> --port=5432 --username=postgres --password --dbname=<db-name> > dump.sql

Import Database (plain text)

psql --host=<host> --port=5432 --username=postgres --password --dbname=<db-name> < dump.sql