posgresql pg_restore cmd

1. after install, connect to db.

sudo -u postgres psql

 

2. create database to push data

create database p04;

 

3. restore with dump file(postgresql)

pg_restore --verbose  -Fc -j 8 --clean --no-acl --no-owner --dbname=p04 dump.sql