| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Arsalan Zaidi <azaidi(at)directi(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Distributing index's/tables/logs/etc. |
| Date: | 2002-02-04 03:13:42 |
| Message-ID: | 200202040313.g143Dgn03164@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2002-02-04 03:50:14 | Re: Comparision of DBs (new to list) |
| Previous Message | Hiroshi Inoue | 2002-02-04 01:03:07 | Re: PostgreSQL transaction locking problem |