Re: Add a new disk to data directory - Mailing list pgsql-admin

From Michelle Konzack
Subject Re: Add a new disk to data directory
Date
Msg-id 20050727165745.GN8540@freenet.de
Whole thread Raw
In response to Add a new disk to data directory  (jose fuenmayor <jafn82@gmail.com>)
Responses Re: Add a new disk to data directory  (Hans Peter Wiedau <hpw-nl@quelltext.com>)
List 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)

Attachment

pgsql-admin by date:

Previous
From: "Gregory Zelesnik"
Date:
Subject: libpq.so.3 compatability problem still there for 8.0.3 installs
Next
From: Devrim GUNDUZ
Date:
Subject: Re: libpq.so.3 compatability problem still there for 8.0.3