Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving a PostgreSQL database to a new tablespace - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Moving a PostgreSQL database to a new tablespace
Date
Msg-id CAHyXU0x-Wx67tJpzmJm3Vkg_7cSnszLrgZHOOC6+9WUNXyA5yg@mail.gmail.com
Whole thread Raw
In response to Moving a PostgreSQL database to a new tablespace  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
Tree view 
On Mon, Aug 8, 2011 at 5:09 PM, JORGE MALDONADO <jorgemal1960@gmail.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

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: Moving a PostgreSQL database to a new tablespace
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Datetime stored in bigint