Add a new disk to data directory
Add a new disk to data directory
От:
jose fuenmayor <jafn82@gmail.com>
Дата:
Hi all, I need to add a new disk to the data directory of postrgreSql ( the one i ve got is running out of space), how can i do that?, i have postgreSql 8.0.3 on a Mandrake Linux 10.1 machine (hp proliant ml350 g3) Do I have to use LVM (Logical Volume Manager)? Is there any workaround in postgreSQL? I will apreciate any help you people could give me. All yours Ing.Jose A Fuenmayor Nava.
Re: Add a new disk to data directory
Am 2005-07-27 12:03:55, schrieb jose fuenmayor:
> Hi all,
>
> I need to add a new disk to the data directory of postrgreSql ( the
> one i ve got is running out of space), how can i do that?, i have
> postgreSql 8.0.3 on a Mandrake Linux 10.1 machine (hp proliant ml350
> g3)
>
> Do I have to use LVM (Logical Volume Manager)?
I think, using LVM on a database is very risky.
> Is there any workaround in postgreSQL?
I have changed the whole disk to a 3Ware Raid-5 SATA with
4 and/or 8 Harddisks. This will save your nerves.
Please note, that if you stop the pgsql and flush the
diskcache you can copy the pgsql-data-dir to the new location.
> I will apreciate any help you people could give me.
>
> All yours
> Ing.Jose A Fuenmayor Nava.
Greetings
Michelle
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)
Re: Add a new disk to data directory
От:
Hans Peter Wiedau <hpw-nl@quelltext.com>
Дата:
On Wed, Jul 27, 2005 at 06:57:45PM +0200, Michelle Konzack wrote: > I think, using LVM on a database is very risky. Why? Hans Peter -- ///// Quelltext AG -- Professional Software Services // // Hans Peter Wiedau , CEO // // Ostenhellweg 31, 44135 Dortmund, Germany // \\/ fon +49 231 9503750, fax +49 231 9503751 ////\\ Web http://www.quelltext.com