>I am putting together a large database and want the
>table to reside on a partition separate from the
>default under 'base'. How can I do this?
You could create symlinks for the larger tables pointing to another location:
ln -s /path/to/table/bigtable /usr/local/pgsql/data/base/whatever/bigtable
(supposed /usr/local/pgsql is your Postgres directory)
If there are serious troubles to be expected, I'd like to know that, because we have used this method once (not so
importantDB, without any probs till now)
Stefan
--
Atheism is a non-prophet organization.