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
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: