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

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 (view raw or flat)
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

pgsql-novice by date

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

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