Hi,
    I have two questions

1. Is it possible to set up a set of redundant disks for a database? one

of them being remote from
    the database?


2. If I want to use my i/o routines for disk i/o, is it possible?
    does postgres support such APIs?




thanks,
Sandeep




Tue, 28 Nov 2000 19:30:33 -0800
Sandeep Joshi <sjoshi@Zambeel.com>
redundancy and disk i/o
On Tue, 28 Nov 2000, Sandeep Joshi wrote:

> 1. Is it possible to set up a set of redundant disks for a database? one 
> of them being remote from the database?

Call IBM Global Services, and tell them you are interested in purchasing
an RS/6000 with a 7133 SSA drives, one tray off-site using the fiber
extenders.

With those, you can have your drives up to 2.4 km from the server they're
connected to, while they still are local to the machine. (And you still
get 4 simultaneous reads/writes in each direction of the loop, for a total
of 160 Mbyte/sec transfer.)


-- 
Dominic J. Eidson
                                        "Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/              http://www.the-infinite.org/~dominic/


Mon, 4 Dec 2000 01:03:03 -0600 (CST)
"Dominic J. Eidson" <sauron@the-infinite.org>
Re: redundancy and disk i/o
At 07:30 PM 11/28/00 -0800, Sandeep Joshi wrote:
>Hi,
>    I have two questions
>
>1. Is it possible to set up a set of redundant disks for a database? one
>of them being remote from the database?

If you're talking about replication, PostgreSQL, Inc. will be offering a
solution to its $19,000/yr Platinum Partners shortly.  It will be released
in open source form no more than two years after its release in proprietary
form.

Check out http://www.erserver.com for more details, and http://www.pgsql.com
for more details on the PostgreSQL, Inc. partnership program.

Locally, you can use RAID.  Are there open-source journaling filesystems that
offer filesystem-level replication out there?



- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.

Sun, 03 Dec 2000 23:18:32 -0800
Don Baccus <dhogaza@pacifier.com>
Re: redundancy and disk i/o
> If you're talking about replication, PostgreSQL, Inc. will be offering a
> solution to its $19,000/yr Platinum Partners shortly.  It will be released
> in open source form no more than two years after its release in proprietary
> form.
> Check out http://www.erserver.com for more details, and http://www.pgsql.com
> for more details on the PostgreSQL, Inc. partnership program.

Thanks Don for the reference. As you know, there will also be a "roll
your own" replication toolset contributed by PostgreSQL Inc. under the
BSD license in the PostgreSQL contrib/ directory for the 7.1 release,
assuming that this inclusion is acceptable to the community. Given the
general interest, I hope that this won't be an issue, and that the
recent flames will have died down enough to not be a continued
distraction.

                  - Thomas

Mon, 04 Dec 2000 18:09:28 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: redundancy and disk i/o