Re: Does PostgreSQL Stores its database in multiple disks?

From: Heather Johnson <hjohnson(at)nypost(dot)com>
To: Igor Maciel Macaubas <igor(at)providerst(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Does PostgreSQL Stores its database in multiple disks?
Date: 2004-10-01 21:17:44
Message-ID: 415DC978.9030209@nypost.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)providerst(dot)com(dot)br <mailto:igor(at)providerst(dot)com(dot)br>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Paesold 2004-10-01 21:22:39 Re: PLEASE GOD HELP US!
Previous Message William Yu 2004-10-01 21:14:04 Re: PLEASE GOD HELP US!