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

Re: Moving a table to another directory

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "Ezequiel Luis Pellettieri" <ezequiel(dot)pellettieri(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Moving a table to another directory
Date: 2007-02-06 03:33:20
Message-ID: c2d9e70e0702051933t6d7af5qa2ab96f1a768d23@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On 2/5/07, Ezequiel Luis Pellettieri <ezequiel(dot)pellettieri(at)gmail(dot)com> wrote:
> Jaime you mean that moving all table files and pointing the symlink to the
> first one will work?
> and doing the same with its index too...?
>

no, IIRC, you need a symlink per table's file, the same for index's files...
you shoukd think in upgrading... ;)

-- 
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

In response to

pgsql-admin by date

Next:From: Achilleas MantziosDate: 2007-02-06 07:46:34
Subject: Re: destroyed db/index (corruption)
Previous:From: Ezequiel Luis PellettieriDate: 2007-02-06 03:28:42
Subject: Re: Moving a table to another directory

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