Skip to content

Instantly share code, notes, and snippets.

@samcre

samcre/gist:dfeb5146e7b4f71a9c92fb176f079e2b

Created July 18, 2019 14:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samcre/dfeb5146e7b4f71a9c92fb176f079e2b to your computer and use it in GitHub Desktop.
Save samcre/dfeb5146e7b4f71a9c92fb176f079e2b to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL dumps without owner and ACLs
Raw
gistfile1.txt
# Source: https://serverfault.com/questions/228170/export-and-import-a-postgresql-database-with-a-different-name
pg_dump --no-owner --no-acl blah > blah.psql
psql blah_devel < blah.psql > /dev/null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment