RE: [NOVICE] RE: Sizing of LARGE databases.

Francisco,

Excellent idea.

Thanks for the info.  Is this what you are doing now?  And if so, since the
current version does not appear to have replication, have you found a
workaround?

-Michael

> -----Original Message-----
> From: Francisco Reyes [mailto:fran@reyes.somos.net]
> Sent: Thursday, February 01, 2001 10:20 PM
> To: Michael Miyabara-McCaskey
> Cc: 'Justin Clift'; pgsql-novice@postgresql.org;
> pgsql-general@postgresql.org
> Subject: Re: [NOVICE] RE: Sizing of LARGE databases.
>
>
> 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.
>