Re: [GENERAL] Omitting tablespace creation from pg_dumpall...

2006-06-16 Thread Tom Lane
Bruce Momjian writes: > Should pg_dumpall be using the "SET default_tablespace = foo" method as > well? That would mean changing the semantics of CREATE DATABASE; currently it copies the default tablespace from the template database, rather than looking at default_tablespace. I'm unsure if that'

Re: [GENERAL] Omitting tablespace creation from pg_dumpall...

2006-06-16 Thread Chander Ganesan
Florian G. Pflug wrote: Chander Ganesan wrote: Tom Lane wrote: Chander Ganesan <[EMAIL PROTECTED]> writes: 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 painfu

Re: [GENERAL] Omitting tablespace creation from pg_dumpall...

2006-06-16 Thread Bruce Momjian
Should pg_dumpall be using the "SET default_tablespace = foo" method as well? --- Florian G. Pflug wrote: > Chander Ganesan wrote: > > Tom Lane wrote: > >> Chander Ganesan <[EMAIL PROTECTED]> writes: > >> > >>> I'd like to

Re: [GENERAL] Omitting tablespace creation from pg_dumpall...

2006-06-16 Thread Florian G. Pflug
Chander Ganesan wrote: Tom Lane wrote: Chander Ganesan <[EMAIL PROTECTED]> writes: 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 mig

Re: [GENERAL] Omitting tablespace creation from pg_dumpall...

2006-06-15 Thread Chander Ganesan
Tom Lane wrote: Chander Ganesan <[EMAIL PROTECTED]> writes: 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 f

Re: [GENERAL] Omitting tablespace creation from pg_dumpall...

2006-06-15 Thread Tom Lane
Chander Ganesan <[EMAIL PROTECTED]> writes: > 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 prod

[GENERAL] Omitting tablespace creation from pg_dumpall...

2006-06-15 Thread Chander Ganesan
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