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

From Olivier Thauvin
Subject Re: one table from the db on a separate drive
Date
Msg-id 200602150747.56720.olivier.thauvin@aerov.jussieu.fr
Whole thread Raw
In response to Re: one table from the db on a separate drive  (Pradeep Parmar <pradeep.dba@gmail.com>)
Responses Re: one table from the db on a separate drive
List pgsql-novice
Le Mercredi 15 Février 2006 07:38, Pradeep Parmar a écrit :
> Hi,
>
> >>What version of PostgreSQL are you using?  If 8.0 or later then
> >>check out tablespaces and ALTER TABLE SET TABLESPACE.
>
> I'm using Postgres 7.4. Is the procedure different in this version than
> Postgres 8.0

Yes, you have to set a envirronement variable pointing to the new location,
restart postgresql with this env variable set, and then setting your table
using the new location:

http://www.postgresql.org/docs/7.4/interactive/manage-ag-alternate-locs.html

Attachment

pgsql-novice by date:

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