Arsalan Zaidi wrote:
> Hi.
>
> I'd like to place my indexs on another partition. There's a hint that this
> can be done in one of the docs, but no info as to how one should go about
> doing this...
>
> I can guess which of the directories under 'base' holds my database, but how
> do I recognise and shift the indexs? They're all numbers!
Use /contrib/oid2name to make file numbers to table/database names.
Then shut down the database and symlink indexes to another device.
That's all it takes.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026