Backup/restore/Migrate database

pg_dump -U twenty -h localhost -p 5432 -Fc default > db_twenty.dump 

docker cp ../db_twenty.dump twenty-db-1:
docker exec -it twenty-db-1 /bin/bash

dropdb -U twenty -h localhost -p 5432 default
createdb  -U twenty -h localhost -p 5432 default

cd

pg_restore -U twenty -h localhost -p 5432 -C --clean --create --if-exists -d default db_twenty.dump 
Password: 
pg_restore: error: could not execute query: ERROR:  cannot drop the currently open database
Command was: DROP DATABASE IF EXISTS "default";
pg_restore: error: could not execute query: ERROR:  database "default" already exists
Command was: CREATE DATABASE "default" WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'en_US.UTF-8';


pg_restore: warning: errors ignored on restore: 2

docker exec -it twenty-server-1 sh

/app/packages/twenty-server $ yarn database:migrate:prod

docker-compose restart