Monthly Archives: October 2010

To dump only schema and/or role for a database

To dump only schema and role for a database command: pg_dumpall -s -l v4 -U postgres -f pg_dump_schema_roles_20101012.dmp to reload the schema psql -U postgres -f <file_name> To dump only roles for a database pg_dumpall -r -l v4 -U postgres … Continue reading

Posted in Uncategorized | Leave a comment