Make Backup/Restore Postgres Database With No Owner

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

February 23, 2021 · 1 min · Carlos Ramos