Poznámka — PostgreSQL dump a import

Napsat komentář

Dump DB

pg_dump -U postgres --inserts -O databasename > database.sql

nebo:

pg_dump databasename -U username -W -h 127.0.0.1 -f ./database.sql

Založení DB

psql -U postgres
CREATE ROLE username LOGIN PASSWORD 'passw' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
CREATE DATABASE databasename WITH OWNER = user ENCODING = 'UTF8' LC_COLLATE = 'Czech, Czech Republic' LC_CTYPE = 'Czech, Czech Republic' CONNECTION LIMIT = -1;

Import DB

cat database.sql | psql -U postgres -d database

Windows:

type database.sql | psql -U postgres -d database

nebo

psql -d databasename -U username -h 127.0.0.1 -f database.sql

Napsat komentář