Search Postgresql Archives

A question on PSQL 8.3 setup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 This
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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux