X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D427952C34 for ; Wed, 27 Jul 2005 13:57:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10443-04 for ; Wed, 27 Jul 2005 16:57:50 +0000 (GMT) Received: from mout0.freenet.de (mout0.freenet.de [194.97.50.131]) by svr1.postgresql.org (Postfix) with ESMTP id 3701A52B80 for ; Wed, 27 Jul 2005 13:57:47 -0300 (ADT) Received: from [194.97.55.192] (helo=mx8.freenet.de) by mout0.freenet.de with esmtpa (Exim 4.52) id 1DxpE2-0003og-9K for pgsql-admin@postgresql.org; Wed, 27 Jul 2005 18:57:46 +0200 Received: from astrasbourg-251-1-41-144.w82-126.abo.wanadoo.fr ([82.126.158.144] helo=michelle1.private.tamay-dogan.net) by mx8.freenet.de with esmtpa (ID asmtp.tdnet@freenet.de) (Exim 4.52 #3) id 1DxpE2-0000pe-0g for pgsql-admin@postgresql.org; Wed, 27 Jul 2005 18:57:46 +0200 Received: by michelle1.private.tamay-dogan.net (sSMTP sendmail emulation); Wed, 27 Jul 2005 18:57:45 +0200 Date: Wed, 27 Jul 2005 18:57:45 +0200 From: Michelle Konzack To: pgsql-admin@postgresql.org Subject: Re: Add a new disk to data directory Message-ID: <20050727165745.GN8540@freenet.de> References: <69f2062a05072709034b2b6b48@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="+Hr//EUsa8//ouuB" Content-Disposition: inline In-Reply-To: <69f2062a05072709034b2b6b48@mail.gmail.com> X-Message-Flag: Improper configuration of Outlook is a breeding ground for viruses. Please take care your Client is configured correctly. Greetings Michelle. X-Disclaimer-DE: Eine weitere Verwendung oder die Veroeffentlichung dieser Mail oder dieser Mailadresse ist nur mit der Einwilligung des Autors gestattet. Organisation: Michelle's Selbstgebrautes X-Operating-System: Linux michelle1.private 2.4.27-2-k7 X-Uptime: 18:53:59 up 4 days, 21:48, 3 users, load average: 0.44, 0.48, 0.47 X-Homepage-1: http://www.debian.tamay-dogan.homelinux.net/ X-Homepage-2: http://michelle.konzack.home.tamay-dogan.homelinux.net/ User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.093 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/228 X-Sequence-Number: 18284 --+Hr//EUsa8//ouuB Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Am 2005-07-27 12:03:55, schrieb jose fuenmayor: > Hi all, >=20 > 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) >=20 > 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. >=20 > All yours > Ing.Jose A Fuenmayor Nava. Greetings Michelle --=20 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) --+Hr//EUsa8//ouuB Content-Type: application/pgp-signature; name="signature.pgp" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFC570JC0FPBMSS+BIRAuFYAJ9m7S3xjLY1mMQUQ7dK7PTTcFkrFgCguwzo cqkUgzliC0ecs5TirwDRCII= =QqXC -----END PGP SIGNATURE----- --+Hr//EUsa8//ouuB--