pg_dump, pg_restore and tablespaces

From: Colton Smith <smith(at)skio(dot)peachnet(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump, pg_restore and tablespaces
Date: 2005-11-29 19:35:12
Message-ID: 438CAD70.4050005@skio.peachnet.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrea 2005-11-29 20:16:16 Fatal : IDENT authentication
Previous Message Tom Lane 2005-11-29 16:35:14 Re: command line options to pass to the postmaster - controlling UNIX socket permiss