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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to