Feature request: pg_restore with tablespace rules

From: Tim Kane <tim(dot)kane(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Feature request: pg_restore with tablespace rules
Date: 2013-05-13 10:50:51
Message-ID: CADVWZZLhscy5SXh9BiadGSwOos8h6UOF1RCB12kFhT25Bni=Zg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all...

Forgive me if this is not the correct forum for such suggestions.

I'm about to begin using the custom format options for pg_restore, so that
we can leverage the performance gains from --jobs options.
However I would like to be able to specify the tablespace for individual
tables/indexes at the time of the restore operation.

Is this something that could be achieved using the pg_restore -L style
list files? I realise that there is no tablespace information exposed in
this output at this time, but it could be a logical way to achieve this
kind of behaviour in the future?

For now I will look at ALTER'ing the individual tables/indexes post-restore

Cheers,

Tim

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra 2013-05-13 11:57:47 Re: PAM implementation in PG 9.2.3
Previous Message Arvind Singh 2013-05-13 10:08:03 Re: PG Stats Collector