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.
>