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 42B9232A1FD for ; Fri, 1 Oct 2004 22:18:19 +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 62567-06 for ; Fri, 1 Oct 2004 21:18:15 +0000 (GMT) Received: from gwen.enluminaire.com (h-67-100-183-100.nycmny83.covad.net [67.100.183.100]) by svr1.postgresql.org (Postfix) with ESMTP id C872832A1D6 for ; Fri, 1 Oct 2004 22:18:16 +0100 (BST) Received: from [192.168.1.200] (unknown [192.168.1.200]) by gwen.enluminaire.com (Postfix) with ESMTP id 98658183E3D; Fri, 1 Oct 2004 17:18:11 -0400 (EDT) Message-ID: <415DC978.9030209@nypost.com> Date: Fri, 01 Oct 2004 17:17:44 -0400 From: Heather Johnson User-Agent: Mozilla Thunderbird 0.8 (X11/20040918) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Igor Maciel Macaubas Cc: pgsql-admin@postgresql.org Subject: Re: Does PostgreSQL Stores its database in multiple disks? References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> In-Reply-To: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> X-Enigmail-Version: 0.86.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/32 X-Sequence-Number: 15026 Could you configure the two volumes as one volume with RAID? If so, then Postgres shouldn't require any special adjusting to accomplish what you are after. Heather Johnson Senior Database Programmer New York Post Igor Maciel Macaubas wrote: > Hi Guys, > > I have a PostgreSQL server, running 7.4.2, that will store a really > large amount of data (200GB) being migrated from an Oracle database. I > have a machine 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 > system (ext3)? > Does anyone ever stored a database (see, it's ONE database only, not a > cluster) on multiple disks ? > > What about PgSQL 8? It'll include this feature? > > Thanks! > > Regards, > Igor > -- > igor@providerst.com.br >