Postgres Pro
Downloads
Home   >   mailing lists

Re: one table from the db on a separate drive - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: one table from the db on a separate drive
Date
Msg-id 20060215061343.GA18481@webserv.wug-glas.de
Whole thread Raw
In response to one table from the db on a separate drive  (Pradeep Parmar <pradeep.dba@gmail.com>)
List pgsql-novice
Tree view 
am  15.02.2006, um 11:25:03 +0530 mailte Pradeep Parmar folgendes:
> 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??

You can create a new tablespace and use this. Read
http://www.postgresql.org/docs/8.1/interactive/manage-ag-tablespaces.html


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

Previous
From: Pradeep Parmar
Date:
Subject: one table from the db on a separate drive
Next
From: Michael Fuhr
Date:
Subject: Re: one table from the db on a separate drive