Is there an easy and safe way to migrate a database to a new tablespace?

From: "David Young" <randomfire(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Is there an easy and safe way to migrate a database to a new tablespace?
Date: 2007-11-26 21:05:17
Message-ID: d3feac2a0711261305l33a4830bob6df418248338115@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I recently converted to using a postgresql engine that support tablespaces.
There's a database that I would like to move to a new tablespace for
performance reasons. What is the safe and correct way of doing this? The
documentation is a bit sketchy on this.

Thanks in advance,
David

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-11-26 22:10:26 Re: database cluster missing
Previous Message Jose Calderon 2007-11-26 20:16:55 database cluster missing