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
