Capacic

Appearance

Create database ​

bash

CREATE DATABASE fi_demo
WITH OWNER = capacic
TEMPLATE = 'template0'
ENCODING = 'UTF8'
LC_COLLATE = 'fi_FI.UTF-8'
LC_CTYPE = 'fi_FI.UTF-8'
CONNECTION LIMIT = -1;

# in capacic:

cd ~/backup
sudo -s
pg_dump -h localhost -U capacic --clean --if-exists fi_demo | gzip -9 > fi_demo_2021-04-29.sql.gz
exit

# in osx:

cd ~/Documents/database/fi_demo
scp capacic@git.capacic.com:/home/capacic/backup/fi_demo_2021-04-29.sql.gz .

cd ~/Documents/database/fi_demo
gunzip < fi_demo_2021-04-29.sql.gz | psql fi_demo -U capacic -h localhost