Moving a tablespace

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I want to move an existing tablespace on an FC8 box.  I read (at
http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html)
that one can simply stop the server, update the symbolic link in
$PGDATA/pg_tblspc, start the server, then update the pg_tablespace
catalog to point to the new location.

Is this all there is to moving a tablespace?  It seems too easy.  

The tablespace I want to move is only around 1GB in size so dropping and
reloading during the next maintenance cycle is not that much of an
issue; although, I'd prefer not to.

Thanks in advance,

Gord



-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux