Re: Restoring to a different tablespace

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joeseph Blowseph" <joseph_blowseph(at)hotmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Restoring to a different tablespace
Date: 2005-12-31 20:27:51
Message-ID: 21233.1136060871@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Joeseph Blowseph" <joseph_blowseph(at)hotmail(dot)com> writes:
> However, if I run a restore, connecting as the new user, the tables are
> owned by the user as expected, but they are going to the default tablespace
> and blowing my C: filesystem.

If that's a pg_dump dump, it very likely includes commands to specify
which tablespace the tables should go into. You'll need to modify the
dump file to override that.

It might work to create a new database with the desired tablespace as
its default, and restore into that database.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-12-31 20:32:41 Re: Limit to mail size?
Previous Message Tom Lane 2005-12-31 20:24:13 Re: PG_Dump Users and Groups