Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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: /bjm/diff
Description: text/x-diff (2.0 KB)

In response to

pgsql-patches by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group