Skip site navigation (1) Skip section navigation (2)

Re: Moving a table to another directory

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Moving a table to another directory
Date: 2007-02-05 20:14:16
Message-ID: 45C79018.2080101@radev.net (view raw or flat)
Thread:
Lists: pgsql-admin
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)


-- 
Milen A. Radev


In response to

Responses

pgsql-admin by date

Next:From: Joshua KramerDate: 2007-02-05 20:18:00
Subject: Re: Backup Strategies?
Previous:From: Ezequiel Luis PellettieriDate: 2007-02-05 19:41:49
Subject: Moving a table to another directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group