A question on PSQL 8.3 setup

Hi, folks?

I'm hoping this is the right mailing list for this sort of question. If not,
I apologize you
any inconvenience in advance, though.

I'm trying to set up postgreql 8.3 in a box running Ubuntu 8.04 and PSQL 8.3
Thisbox is sort of misconfigured because it has 15GB for / and 3 TB for
/home. Due to
the relatively large size of database, about 470 GB, I need to configure
PSQL to store
all DB-related data into /home/pgsql/data instead of somewhere in / such as
/var/lib/
postgresql/8.3/... or /usr/local/pgsql/data. Unfortunately, however, I'm not
allowed to
re-partition but to use the existing ones.

If I'm not mistaken, I can use initdb and tablespace in order to expand
database
clusters and tables to a new location such as /home/pgsql/data. However,
whenever
I try to dump a DB in, it seems to use / and consumes the whole space
assigned
for /, no matter what I do with initdb and tablespace. I might be wrong with
using
initdb and tablespaces, but it's very weird to me, though. It'd be greatly
appreciated if
someone helps me to redirect all DB stuff into /home/pgsql/data directory
instead of
some directories in /. Here are the procedure that I did:

> sudo mkdir /home/pgsql
> sudo mkdir /home/pgsql/data
> sudo chown postgres /home/pgsql/data
> sudo mkdir /home/pgsql/ts
> sudo chown postgres /home/pgsql/ts
> sudo su - postgres
> initdb -D /home/pgsql/data
> pg_ctl -D /home/pgsql/data -l logfile start
> createdb DBNAME
> createuser USER
> psql -s DBNAME
db=> create tablespace dbts location '/home/pgsql/ts';
db=> set default_tablespace=dbts;
>ctrl+D
> exit
> psql db < 470GB_DB_DUMPED_FILE

SET
SET
SET
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
setval
-----------
200607607
(1 row)

ALTER TABLE
ERROR: could not extend relation 1663/16384/21734: No space left on device
HINT: Check free disk space.
CONTEXT: COPY packets, line 22968771: "53 115989288 2008-09-20
23:13:00.640317-06 4 5 1500 14995 2 16384 64 6 26411 64.106.46.186
222.134..."

Thanks a lot,
Jong