Is it possible to move a database to another tablespace?
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?
-----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-----
Francisco Reyes <lists@stringsutils.com> writes:
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?
No. Moving the system catalogs on-the-fly would be an interesting
problem ("uh, where did you say pg_class was? ... and I can't find its
indexes either?"). It could possibly be done, but the complexity would
be far out of proportion to the value I fear.
regards, tom lane