Omitting tablespace creation from pg_dumpall...

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 :-)
--
Chander Ganesan
The Open Technology Group
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com