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

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

pgsql-admin by date

Next:From: Tom LaneDate: 2007-11-26 22:10:26
Subject: Re: database cluster missing
Previous:From: Jose CalderonDate: 2007-11-26 20:16:55
Subject: database cluster missing

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