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 956CF32A151 for ; Fri, 1 Oct 2004 21:56:17 +0100 (BST) 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 56928-02 for ; Fri, 1 Oct 2004 20:56:14 +0000 (GMT) Received: from providerst.com.br (unknown [200.253.138.61]) by svr1.postgresql.org (Postfix) with ESMTP id 535C132A14E for ; Fri, 1 Oct 2004 21:56:13 +0100 (BST) Brma: igor [192.168.1.104] (may be forged) Received: from sistemas (igor [192.168.1.104] (may be forged)) by providerst.com.br (8.11.6/8.11.6) with SMTP id i91KnW614316 for ; Fri, 1 Oct 2004 17:49:32 -0300 Message-ID: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> From: "Igor Maciel Macaubas" To: Subject: Does PostgreSQL Stores its database in multiple disks? Date: Fri, 1 Oct 2004 18:01:23 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002B_01C4A7E0.A990D290" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_FONTCOLOR_BLUE, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200410/31 X-Sequence-Number: 15025 This is a multi-part message in MIME format. ------=_NextPart_000_002B_01C4A7E0.A990D290 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Guys, I have a PostgreSQL server, running 7.4.2, that will store a really large a= mount of data (200GB) being migrated from an Oracle database. I have a mach= ine with two 120GB Ultra ATA IDE disks, and I'd like to know if PostgreSQL = could split it over both disks (that gives me 240GB or storage). Does he do= this automatically ? Or I'll have to split it manually, creating symbolic links on my file syste= m (ext3)? Does anyone ever stored a database (see, it's ONE database only, not a clus= ter) on multiple disks ? What about PgSQL 8? It'll include this feature? Thanks! Regards, Igor -- igor@providerst.com.br ------=_NextPart_000_002B_01C4A7E0.A990D290 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Guys,
 
I have a PostgreSQL server, running 7.4= .2, that=20 will store a really large amount of data (200GB) being migrated from an Oracle database. I have a machine with two = 120GB=20 Ultra ATA IDE disks, and I'd like to know if PostgreSQL could split it over= both=20 disks (that gives me 240GB or storage). Does he do this automatically=20 ?
Or I'll have to split it manually, crea= ting=20 symbolic links on my file system (ext3)?
Does anyone ever stored a database (see= , it's=20 ONE database only, not a cluster) on multiple disks ?
 
What about PgSQL 8? It'll include this= =20 feature?
 
Thanks!
 
Regards,
Igor
--
igor@providerst.com.br
 
------=_NextPart_000_002B_01C4A7E0.A990D290--