Re: one table from the db on a separate drive

At 02:06 AM 2/15/06, Pradeep Parmar wrote:
>I went thru the docs at this link:
>
><http://www.postgresql.org/docs/7.4/interactive/manage-ag-alternate-locs.html>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

- Identify file to be moved (see docs)
- shutdown postmaster
- use shell command to move file
- create link from old location to new location
- restart postmaster

Caveat: I'm guessing that if you drop/create table it will go back to
original location.