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

Re: Moving a PostgreSQL database to a new tablespace

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Moving a PostgreSQL database to a new tablespace
Date: 2011-08-08 22:14:54
Message-ID: CAHyXU0x-Wx67tJpzmJm3Vkg_7cSnszLrgZHOOC6+9WUNXyA5yg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Mon, Aug 8, 2011 at 5:09 PM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> wrote:
> Is there a way to move an entire PostgreSQL database from one tablespace
> to a new one? Of course, I do not want to ALTER each object and SET the new
> tablespace.

'did you try alter database set tablespace'?

merlin

In response to

pgsql-novice by date

Next:From: Greg Sabino MullaneDate: 2011-08-09 01:10:19
Subject: Re: Datetime stored in bigint
Previous:From: JORGE MALDONADODate: 2011-08-08 22:09:30
Subject: Moving a PostgreSQL database to a new tablespace

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