pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Add a new disk to data directory
3+ messages / 3 participants
[nested] [flat]

* Add a new disk to data directory
@ 2005-07-27 16:03 jose fuenmayor <jafn82@gmail.com>
  2005-07-27 16:57 ` Re: Add a new disk to data directory Michelle Konzack <linux4michelle@freenet.de>
  0 siblings, 1 reply; 3+ messages in thread

From: jose fuenmayor @ 2005-07-27 16:03 UTC (permalink / raw)
  To: pgsql-admin

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.



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

* Re: Add a new disk to data directory
  2005-07-27 16:03 Add a new disk to data directory jose fuenmayor <jafn82@gmail.com>
@ 2005-07-27 16:57 ` Michelle Konzack <linux4michelle@freenet.de>
  2005-07-28 09:50   ` Re: Add a new disk to data directory Hans Peter Wiedau <hpw-nl@quelltext.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Michelle Konzack @ 2005-07-27 16:57 UTC (permalink / raw)
  To: pgsql-admin

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)

Attachments:

  signature.pgp (application/pgp-signature, 188B) download

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

* Re: Add a new disk to data directory
  2005-07-27 16:03 Add a new disk to data directory jose fuenmayor <jafn82@gmail.com>
  2005-07-27 16:57 ` Re: Add a new disk to data directory Michelle Konzack <linux4michelle@freenet.de>
@ 2005-07-28 09:50   ` Hans Peter Wiedau <hpw-nl@quelltext.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Hans Peter Wiedau @ 2005-07-28 09:50 UTC (permalink / raw)
  To: pgsql-admin

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



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


end of thread, other threads:[~2005-07-28 09:50 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-27 16:03 Add a new disk to data directory jose fuenmayor <jafn82@gmail.com>
2005-07-27 16:57 ` Michelle Konzack <linux4michelle@freenet.de>
2005-07-28 09:50   ` Hans Peter Wiedau <hpw-nl@quelltext.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