Re: Is it possible to move a database to another tablespace?

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Is it possible to move a database to another tablespace?
Date: 2007-04-19 21:25:30
Message-ID: 4627DE4A.60109@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 04/19/07 14:51, Francisco Reyes wrote:
> I see tables and indexes can be moved to a different tablespace.
> Is there any way to move an entire database to a different tablespace?

Move one table at a time?

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGJ95KS9HxQb37XmcRAloBAKDC+j/yS4r6dQXiY2kKUQMXUaHtYgCggy+A
JIeqTvU4Q4zZR+gX9q/6mNk=
=bIOU
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2007-04-19 21:45:47 dollar-quoting trouble
Previous Message Ron Johnson 2007-04-19 21:24:38 Re: Can Postgresql be ported to a device with no OS and simple file I/O and memory management?