Question relating to database space and adding partition

Поиск
Список
Период
Сортировка
От Karthikeyan Sundaram
Тема Question relating to database space and adding partition
Дата
Msg-id BAY131-F324B78FC3F8C804FF6260B0980@phx.gbl
обсуждение исходный текст
Ответы Re: Question relating to database space and adding partition  ("Joshua D. Drake" <jd@commandprompt.com>)
how to add a new data partition  ("Karthikeyan Sundaram" <skarthi98@hotmail.com>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: destroyed db/index (corruption)
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Question relating to database space and adding partition