Re: one table from the db on a separate drive

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Pradeep Parmar <pradeep(dot)dba(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: one table from the db on a separate drive
Date: 2006-02-15 06:14:42
Message-ID: 20060215061442.GA3950@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Feb 15, 2006 at 11:25:03AM +0530, Pradeep Parmar wrote:
> how can i place a table from my db on a separate drive than the whole
> database. I have 2 HDD in my system and my db resides on one of them. i want
> to move a single table from one hdd to another on the same system.
> Is it posible? if yes, how??

What version of PostgreSQL are you using? If 8.0 or later then
check out tablespaces and ALTER TABLE SET TABLESPACE.

http://www.postgresql.org/docs/8.1/interactive/manage-ag-tablespaces.html
http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html

--
Michael Fuhr

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Olivier Thauvin 2006-02-15 06:17:08 Re: one table from the db on a separate drive
Previous Message A. Kretschmer 2006-02-15 06:13:43 Re: one table from the db on a separate drive