Re: one table from the db on a separate drive
| От | Pradeep Parmar |
|---|---|
| Тема | Re: one table from the db on a separate drive |
| Дата | |
| Msg-id | 580055310602142306h28c183e0g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: one table from the db on a separate drive (Olivier Thauvin <olivier.thauvin@aerov.jussieu.fr>) |
| Ответы |
Re: one table from the db on a separate drive
|
| Список | pgsql-novice |
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
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.thauvin@aerov.jussieu.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
В списке pgsql-novice по дате отправления: