PostgreSQL snippets (create database, create user, dump, restore)

postgresql-snippets.md

Go to PostgreSQL CLI:

su - postgres
psql

Create user SQL

create user USER with password PASSWORD;

Create database with Russian locale SQL

create database DATABASE with owner USER encoding 'UTF-8' lc_collate = 'ru_RU.utf8' lc_ctype = 'ru_RU.utf8' template = template0;

Dump

su - postgres -c '/usr/bin/pg_dump -Fc $(DATABASE) > $(DATABASE)-$(date +"%Y-%m-%d-%H-%M").dump'

Restore

su - postgres -c '/usr/bin/pg_restore -d $(DATABASE) --role=$(OWNER) --no-owner DUMP_FILE_NAME'