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

Re: one table from the db on a separate drive

From: Olivier Thauvin <olivier(dot)thauvin(at)aerov(dot)jussieu(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: one table from the db on a separate drive
Date: 2006-02-15 06:17:08
Message-ID: 200602150717.12568.olivier.thauvin@aerov.jussieu.fr (view raw or flat)
Thread:
Lists: pgsql-novice
Le Mercredi 15 Février 2006 06:55, Pradeep Parmar a écrit :
> Hi,
>
> 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??

If you are using postgresql 8.0 or highter:

http://www.postgresql.org/docs/8.1/static/manage-ag-tablespaces.html

and change the tablespace of you table.

Otherwise you have to play with env variable with lower version, don't 
remember how.


>
> Regards
>
> Pradeep

In response to

pgsql-novice by date

Next:From: Pradeep ParmarDate: 2006-02-15 06:38:43
Subject: Re: one table from the db on a separate drive
Previous:From: Michael FuhrDate: 2006-02-15 06:14:42
Subject: Re: one table from the db on a separate drive

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