Re: HowTo move indices' files to other hdd ? - Mailing list pgsql-general

On Mon, 15 Jul 2002, Vitaliy Pylypiv wrote:

> Hi all!
>
> Is it possible to move  indices' files to other hdd ?

Yes.  Here's what you need to do:

first, go to the postgresql-7.x.x/contrib/oid2name directory (as root) and
do a make;make install so you have the oid2name utility installed.

then, do:

oid2name | grep dbname

where dbname is the name of the database you want to move an index around
on.  You should get a line like 10964230 = dbname back..

As the postgres superuser, do:

cd $PGDATA/base/oidfromoid2nameabove  (i.e. 10964230 in my example)

Next do:

oid2name -d dbname|grep indexname

to get the oid of the index.

Then, shutdown the server and cp your index elsewhere:

pg_ctl stop
cp 10965165 /mnt/indexdisk/10965165
rm 10965165
ln -s /mnt/indexdisk/10965165
pg_ctl start

And that's that.