SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 05:03 AM
| ||||
| ||||
 Add a new disk to data directory 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster      |
|
04-10-2008, 05:03 AM
| |||
| |||
| 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) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFC570JC0FPBMSS+BIRAuFYAJ9m7S3xjLY1mMQUQ7dK7P TTcFkrFgCguwzo cqkUgzliC0ecs5TirwDRCII= =QqXC -----END PGP SIGNATURE----- |
|
04-10-2008, 05:03 AM
| ||||
| ||||
| Re: Add a new disk to data directory 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 <hpw-nl@quelltext.com>, CEO // // Ostenhellweg 31, 44135 Dortmund, Germany // \\/ fon +49 231 9503750, fax +49 231 9503751 ////\\ Web http://www.quelltext.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
Linear Mode
