pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ezequiel Luis Pellettieri <ezequiel.pellettieri@gmail.com>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Jaime Casanova <systemguards@gmail.com>
Cc: Milen A. Radev <milen@radev.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Moving a table to another directory
Date: Wed, 7 Feb 2007 16:27:30 +0000
Message-ID: <86aad3420702070827u78e38b7ch5749184de178299f@mail.gmail.com> (raw)
In-Reply-To: <1170776691.5451.93.camel@state.g2switchworks.com>
References: <86aad3420702051141u6903bc7evea2ff90dd9ecda00@mail.gmail.com>
	<45C79018.2080101@radev.net>
	<86aad3420702051826g321829a1t3c0f112819c6e767@mail.gmail.com>
	<c2d9e70e0702051903pf281bbdnf9a135902fa62a42@mail.gmail.com>
	<1170776691.5451.93.camel@state.g2switchworks.com>

thanks guys, is it possible to go with it, without stopping the postmaster?
maybe just rejecting conns to the DB...
this is cos I had another DB's running...

thanks again.

pelle.-

2007/2/6, Scott Marlowe <smarlowe@g2switchworks.com>:
>
> On Mon, 2007-02-05 at 21:03, Jaime Casanova wrote:
> > > 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...
>
> Note that you've also got the option of using initlocation.  This only
> allows you to create entire databases on alternate storage location, not
> individual tables.
>
> If you DO go with symlinks, certain operations may result in losing the
> link and recreating the table in the local directory (i.e. anything that
> would change the OID assigned to that table, as I believe cluster and
> reindex would do)
>
> See
> http://www.postgresql.org/docs/7.4/static/app-initlocation.html
> and
> http://www.postgresql.org/docs/7.4/static/sql-createdatabase.html
>
> But my primary recommendation is to upgrade to AT LEAST 8.1 version of
> PostgreSQL.  Now that 8.2.2 is out, I'd consider going to it.  7.4 is
> getting pretty long in the tooth by comparison.
>



-- 
Saludos cordiales. Ezequiel L. Pellettieri


view thread (9+ messages)  latest in thread

Message-ID: <86aad3420702070827u78e38b7ch5749184de178299f@mail.gmail.com>
Permalink:  ../86aad3420702070827u78e38b7ch5749184de178299f@mail.gmail.com/
Also on:    postgresql.org/message-id/86aad3420702070827u78e38b7ch5749184de178299f@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: ezequiel.pellettieri@gmail.com, smarlowe@g2switchworks.com, systemguards@gmail.com, milen@radev.net
  Subject: Re: Moving a table to another directory
  In-Reply-To: <86aad3420702070827u78e38b7ch5749184de178299f@mail.gmail.com>
  References: <86aad3420702051141u6903bc7evea2ff90dd9ecda00@mail.gmail.com> <45C79018.2080101@radev.net> <86aad3420702051826g321829a1t3c0f112819c6e767@mail.gmail.com> <c2d9e70e0702051903pf281bbdnf9a135902fa62a42@mail.gmail.com> <1170776691.5451.93.camel@state.g2switchworks.com> <86aad3420702070827u78e38b7ch5749184de178299f@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