Re: Replication Syatem

------=_Part_5681_30320931.1209392328729
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Salman,

Slony don't do automatic failover. And we would appreciate a system with
automatic failover :(

~ Gauri


On Mon, Apr 28, 2008 at 7:46 PM, salman <salmanb@[EMAIL PROTECTED]
>
wrote:

> Gauri Kanekar wrote:
>
> > Peter,
> >
> > We are doing vacuum full every alternate day. We also do vacuum
analyze
> > very
> > often.
> > We are currently using 8.1.3 version.
> > Auto vacuum is already on. But the table1 is so busy that auto vacuum
> > don't
> > get sufficient chance to vacuum it :(.
> >
> > Have already tried all the option listed by you, thats y we reached to
> > the
> > decision of having a replication sytsem. So any suggestion on that :).
> >
> > Thanx
> > ~ Gauri
> >
> >
> We use slony for exactly this type of a situation. It's not the most
> user-friendly piece of software, but it works well enough that I can
> schedule maintenance windows (we're a 24/7 shop) and do clustering and
other
> tasks on our DB to reclaim space, etc.
>
> -salman
>



-- 
Regards
Gauri

------=_Part_5681_30320931.1209392328729
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Salman,<br><br>Slony don&#39;t do automatic failover. And we would
appreciate a system with automatic failover :(<br><br>~
Gauri<br><br><br><div class="gmail_quote">On Mon, Apr 28, 2008 at 7:46 PM,
salman &lt;<a
href="mailto:salmanb@[EMAIL PROTECTED]
">salmanb@[EMAIL PROTECTED]
>&gt;
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div
class="Ih2E3d">Gauri Kanekar wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); padding-left: 1ex;">
Peter,<br>
<br>
We are doing vacuum full every alternate day. We also do vacuum analyze
very<br>
often.<br>
We are currently using 8.1.3 version.<br>
Auto vacuum is already on. But the table1 is so busy that auto vacuum
don&#39;t<br>
get sufficient chance to vacuum it :(.<br>
<br>
Have already tried all the option listed by you, thats y we reached to
the<br>
decision of having a replication sytsem. So any suggestion on that :).<br>
<br>
Thanx<br>
~ Gauri<br>
<br>
</blockquote>
<br></div>
We use slony for exactly this type of a situation. It&#39;s not the most
user-friendly piece of software, but it works well enough that I can
schedule maintenance windows (we&#39;re a 24/7 shop) and do clustering and
other tasks on our DB to reclaim space, etc.<br>
<font color="#888888">
<br>
-salman<br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Gauri

------=_Part_5681_30320931.1209392328729--