pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jaime Casanova <systemguards@gmail.com>
To: Ezequiel Luis Pellettieri <ezequiel.pellettieri@gmail.com>
Cc: Milen A. Radev <milen@radev.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Moving a table to another directory
Date: Mon, 5 Feb 2007 22:03:47 -0500
Message-ID: <c2d9e70e0702051903pf281bbdnf9a135902fa62a42@mail.gmail.com> (raw)
In-Reply-To: <86aad3420702051826g321829a1t3c0f112819c6e767@mail.gmail.com>
References: <86aad3420702051141u6903bc7evea2ff90dd9ecda00@mail.gmail.com>
	<45C79018.2080101@radev.net>
	<86aad3420702051826g321829a1t3c0f112819c6e767@mail.gmail.com>

> 2007/2/5, Milen A. Radev <milen@radev.net>:
> > 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@gmail.com> 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


view thread (9+ messages)  latest in thread

Message-ID: <c2d9e70e0702051903pf281bbdnf9a135902fa62a42@mail.gmail.com>
Permalink:  ../c2d9e70e0702051903pf281bbdnf9a135902fa62a42@mail.gmail.com/
Also on:    postgresql.org/message-id/c2d9e70e0702051903pf281bbdnf9a135902fa62a42@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: systemguards@gmail.com, ezequiel.pellettieri@gmail.com, milen@radev.net
  Subject: Re: Moving a table to another directory
  In-Reply-To: <c2d9e70e0702051903pf281bbdnf9a135902fa62a42@mail.gmail.com>
  References: <86aad3420702051141u6903bc7evea2ff90dd9ecda00@mail.gmail.com> <45C79018.2080101@radev.net> <86aad3420702051826g321829a1t3c0f112819c6e767@mail.gmail.com> <c2d9e70e0702051903pf281bbdnf9a135902fa62a42@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox