Skip site navigation (1) Skip section navigation (2)

Re: Add a new disk to data directory

From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Add a new disk to data directory
Date: 2005-07-27 16:57:45
Message-ID: 20050727165745.GN8540@freenet.de (view raw or flat)
Thread:
Lists: 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)

In response to

Responses

pgsql-admin by date

Next:From: Devrim GUNDUZDate: 2005-07-27 21:31:50
Subject: Re: libpq.so.3 compatability problem still there for 8.0.3
Previous:From: Gregory ZelesnikDate: 2005-07-27 16:42:37
Subject: libpq.so.3 compatability problem still there for 8.0.3 installs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group