Re: Moving a table to another directory

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

 



2007/2/5, Milen A. Radev <milen@xxxxxxxxx>:
> Ezequiel Luis Pellettieri написа:
> > Hi guys I have a big table (25 gb) and a need to move it to another
> > directory cos i'm out of space.
> > making a symlik will be ok? or I have to do something else
> >
>
>
> 1. CREATE TABLESPACE xxx LOCATION 'another_dir'
> (
http://www.postgresql.org/docs/current/static/sql-createtablespace.html);
>
> 2. ALTER TABLE big_table SET TABLESPACE xxx;
>
(http://www.postgresql.org/docs/current/static/sql-altertable.html
)
>
On 2/5/07, Ezequiel Luis Pellettieri <ezequiel.pellettieri@xxxxxxxxx> wrote:
Thanks Milen, does it work on 7.4??


oops... your symlink will be ok... use the contrib oid2name to
identify the files corresponding to that table... and maybe the
indexes as well...

what i remember from the ancient era pre-tablespace (2 or 3 years ago)
is that a pg_dump and/or reindex will return all to it's original
state...

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                      Richard Cook

[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