Omitting tablespace creation from pg_dumpall... - Mailing list pgsql-general

I'd like to suggest that a feature be added to pg_dumpall to remove tablespace definitions/creation from the output.  While the inclusion is important for backups - it's equally painful when attempting to migrate data from a development to production database.  Since PostgreSQL won't create the directory that will contain the tablespace, the tablespace creation will fail.  Following that, any objects that are to be created in that tablespace will fail (since the tablespace doesn't exist).

This means that one could potentially have to search and replace every instance of a tablespace name in a dump file...

Perhaps a flag can be added to simply comment out tablespace definitions (both the creation, and their use in CREATE DATABASE, etc. statements).  This would allow the statement to be uncommented if needed, and allow DBA's to search for and modify tablespace names as needed...

I apologize if this has already been mentioned/suggested :-)