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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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