pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_dump, pg_restore and tablespaces
2+ messages / 2 participants
[nested] [flat]

* pg_dump, pg_restore and tablespaces
@ 2005-11-29 19:35  Colton Smith <smith@skio.peachnet.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Colton Smith @ 2005-11-29 19:35 UTC (permalink / raw)
  To: pgsql-admin

Hi:

  Let's say I have a database comprised of tables scattered over several 
tablespaces.  Suppose I need to move the database to another server and 
I can't
use the same pathnames for the tablespaces.  Am I out of luck when it 
comes to using pg_dump and pg_restore?

Thanks!




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pg_dump, pg_restore and tablespaces
@ 2005-12-06 20:11  Jim C. Nasby <jim@nasby.net>
  parent: Colton Smith <smith@skio.peachnet.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Jim C. Nasby @ 2005-12-06 20:11 UTC (permalink / raw)
  To: Colton Smith <smith@skio.peachnet.edu>; +Cc: pgsql-admin

On Tue, Nov 29, 2005 at 02:35:12PM -0500, Colton Smith wrote:
> Hi:
> 
>  Let's say I have a database comprised of tables scattered over several 
> tablespaces.  Suppose I need to move the database to another server and 
> I can't
> use the same pathnames for the tablespaces.  Am I out of luck when it 
> comes to using pg_dump and pg_restore?

No. You can just create the tablespaces you need with whatever mapping
suits the new server before doing the restore. This will generate an
error during the restore (tablespace already exists), but you can ignore
that. Just make sure the names match up.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-12-06 20:11 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-29 19:35 pg_dump, pg_restore and tablespaces Colton Smith <smith@skio.peachnet.edu>
2005-12-06 20:11 ` Jim C. Nasby <jim@nasby.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox