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.
box 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
