Re: [NOVICE] RE: Sizing of LARGE databases. - Mailing list pgsql-general

From Francisco Reyes
Subject Re: [NOVICE] RE: Sizing of LARGE databases.
Date
Msg-id Pine.BSF.4.32.0102020116510.1877-100000@zoraida.reyes.somos.net
Whole thread Raw
In response to RE: Sizing of LARGE databases.  ("Michael Miyabara-McCaskey" <mykarz@miyabara.com>)
List pgsql-general
On Thu, 1 Feb 2001, Michael Miyabara-McCaskey wrote:
>
> And have you figured out what your upgrade path may be?  For instance, I
> have not been able to find any evidence on how to make PostgreSQL scale
> (clustered nodes, parallel fail-over, high availability etc)


I believe 7.1 will have some level of replication, although it seems 7.2
will be the "replication" release.

I don't know how failover would work, but one possibility may be to use a
program like Understudy which monitors an IP address and if a machine dies
then it seems requests to the secondary machine. That combined with
replication from the database may help prevent down time and may also be
used to increase performance by using round-robin with Understudy.


pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: How do I list all tables?
Next
From: ""
Date:
Subject: Re: How to install SQL 7.0