sudo -u postgres psql

postgres=# create database mydb;

postgres=# create user myuser with encrypted password 'mypass';

postgres=# grant all privileges on database mydb to myuser;

\c database

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

ALTER DATABASE mydb OWNER TO myuser;

DROP SCHEMA public CASCADE; 

CREATE SCHEMA public;

GRANT ALL ON SCHEMA public TO postgres; 

GRANT ALL ON SCHEMA public TO public;

GRANT ALL ON SCHEMA public TO traduser;

sudo -u postgres pg_dump --column-inserts mydb > mydb_dump.sql

sudo -u postgres psql --file my_dump.sql mydb