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:47:52
Message-ID: 200602150747.56720.olivier.thauvin@aerov.jussieu.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Pradeep Parmar 2006-02-15 07:06:02 Re: one table from the db on a separate drive
Previous Message Pradeep Parmar 2006-02-15 06:38:43 Re: one table from the db on a separate drive