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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>, Chander Ganesan <chander(at)otg-nc(dot)com>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [GENERAL] Omitting tablespace creation from pg_dumpall...
Date: 2006-06-16 22:01:32
Message-ID: 200606162201.k5GM1WD20812@candle.pha.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> 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's a good idea or not.
> None of the other properties of a database are handled that way.

Interesting distinction.

I have added a documentation and code comment patch for this.

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Attachment Content-Type Size
/bjm/diff text/x-diff 2.0 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florian G. Pflug 2006-06-17 00:24:12 Re: Fabian Pascal and RDBMS deficiencies in fully implementing
Previous Message Wes 2006-06-16 21:50:09 Online backups and tar

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2006-06-16 22:08:55 Re: plpython improvements
Previous Message Tom Lane 2006-06-16 21:42:12 Re: Omitting tablespace creation from pg_dumpall...