Re: one table from the db on a separate drive

Hi,

I went thru the docs at this link:

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

But, it describes creating database at alternative location.
What i want is to have a table stored on a separate disk than the rest of
the database.
Is there any equivalent of tablespaces (in 8.1) in Postgres 7.4
I'm using Postgres 7.4

Regards

Pradeep

On 15/02/06, Olivier Thauvin <olivier(dot)thauvin(at)aerov(dot)jussieu(dot)fr> wrote:
>
> 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
>
>
>