to do backup:
pg_dump dbname -O -x > backupname.sql
To restore:
psql dbname < backupname.sql
Options documentation:
-O <-- No owner
-x <-- No privileges
to do backup:
pg_dump dbname -O -x > backupname.sql
To restore:
psql dbname < backupname.sql
Options documentation:
-O <-- No owner
-x <-- No privileges