From: | "Rodin A(dot) Porrata" <porrata(at)west(dot)llnl(dot)gov> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | How to place a table on a separate partition? |
Date: | 2001-03-29 18:51:53 |
Message-ID: | Pine.OSF.4.10.10103291030200.11665-100000@west.llnl.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
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?
I tried the following: First I created the place I
wanted to put the table:
mkdir /taos/01/postgres
chown taos /taos/01/postgres
Then I modified the .profile of postgres
so that:
PGDATA2 = /taos/01/postgres
export PGDATA2
then on the command line of the postgres
account I typed
initlocation $PGDATA2
which was successful.
Then I typed
initdb -D $PGDATA2 -i 1095
Now I had to kill the old postmaster and restart it. However,
I could only give it one location to utilize the data base, i.e.,
postmaster -D /taos/01/postgres
createdb -U taos -D $PGDATA2 large_table
So does this mean I have to start a separate postmaster for
the new location? How would I do that?
What we would like is a single postmaster to handle
all database queries, etc. However, for the especially
large table have a special user and table only.
Rodin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-03-29 19:30:52 | Re: PG 7.0.3 & RH 7 IPC problems? |
Previous Message | DHSC Webmaster | 2001-03-29 18:26:38 | Re: PG 7.0.3 & RH 7 IPC problems? |