Re: pg_dump ignore tablespaces - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump ignore tablespaces
Date
Msg-id 806.1184468193@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump ignore tablespaces  ("Gavin M. Roy" <gavinmroy@gmail.com>)
List pgsql-hackers
"Gavin M. Roy" <gavinmroy@gmail.com> writes:
> Recently I ran into an issue where restoring from pg_dump from one machine
> to another with non-matching tablespaces.  The primary issue is that index
> creation will fail if the tablespace does not exist from the dump.  I was
> thinking to best solution for this would be a pg_dump option such as
> --ignore-tablespaces which would not dump any tablespace related data.

We have --no-owner, so --no-tablespace doesn't seem out of line.

It's a bit late for 8.3 but no objection to adding such a feature
for 8.4.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: pg_dump ignore tablespaces
Next
From: "Pavel Stehule"
Date:
Subject: Re: plpgsql and qualified variable names