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