pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question relating to database space and adding partition
2+ messages / 2 participants
[nested] [flat]

* Question relating to database space and adding partition
@ 2007-02-05 18:49 Karthikeyan Sundaram <skarthi98@hotmail.com>
  2007-02-05 18:54 ` Re: Question relating to database space and adding partition Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Karthikeyan Sundaram @ 2007-02-05 18:49 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

   We are using postgres 8.0.1 on our production and 8.2 on our development. 
  The linuix partition is getting full where the database resides.  In few 
weeks our partition will ran out of space so the database will also run out 
of space. We are added another partition of 300GB.  Now my question is, how 
will I point the database to the new partition along with the old one.

   In oracle when we add a datafile, we can tell the location.  I don't know 
how to do this in postgres.

   Can somebody help me?

Regards
skarthi

_________________________________________________________________
From predictions to trailers, check out the MSN Entertainment Guide to the 
Academy Awards® 
http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline1




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Question relating to database space and adding partition
  2007-02-05 18:49 Question relating to database space and adding partition Karthikeyan Sundaram <skarthi98@hotmail.com>
@ 2007-02-05 18:54 ` Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Joshua D. Drake @ 2007-02-05 18:54 UTC (permalink / raw)
  To: Karthikeyan Sundaram <skarthi98@hotmail.com>; +Cc: pgsql-admin

Karthikeyan Sundaram wrote:
> Hi all,
> 
>   We are using postgres 8.0.1 on our production and 8.2 on our
> development.  The linuix partition is getting full where the database
> resides.  In few weeks our partition will ran out of space so the
> database will also run out of space. We are added another partition of
> 300GB.  Now my question is, how will I point the database to the new
> partition along with the old one.
> 
>   In oracle when we add a datafile, we can tell the location.  I don't
> know how to do this in postgres.
> 
>   Can somebody help me?


The easiest way would be to create a new tablespace:

http://www.postgresql.org/docs/8.1/static/manage-ag-tablespaces.html

> 
> Regards
> skarthi
> 
> _________________________________________________________________
> From predictions to trailers, check out the MSN Entertainment Guide to
> the Academy Awards®
> http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline1
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>               http://www.postgresql.org/docs/faq
> 


-- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-02-05 18:54 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-05 18:49 Question relating to database space and adding partition Karthikeyan Sundaram <skarthi98@hotmail.com>
2007-02-05 18:54 ` Joshua D. Drake <jd@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox