|
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 |
