Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: replication
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 15888 of 17437
Post > Topic >>

Re: replication

by ascoja@[EMAIL PROTECTED] ("Asko Oja") Jun 25, 2008 at 09:20 AM

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

Hi

Take a look also on Londiste from SkyTools. It is easy to set up and
manage.
In addition SkyTools contains other useful scripts and tools.
We use Londiste to replicate data ovwe WAN where wal****pping would consume
too much bandwidth.

Asko

On Tue, Jun 24, 2008 at 9:41 AM, Adrian Moisey
<adrian@[EMAIL PROTECTED]
>
wrote:

> Hi
>
> We have a 100GB database (16GB dumped) running on 8.2.
>
> Since the bandwidth in South Africa isn't that freely available it is
> difficult for us to get a new copy of out DB in our office (our fastest
link
> in the office is 4Mbps).
>
> What can you recommend for me to get an up to date copy of my DB in the
> office with as little transfer as possible.
>
> A few ideas I've been toying with are rsyncing a dump of the db, or
> replication.
>
> Any ideas?
>
> --
> Adrian Moisey
> Systems Administrator | CareerJunction | Your Future Starts Here.
> Web: www.careerjunction.co.za | Email: adrian@[EMAIL PROTECTED]
> Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
>
> --
> Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

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

Hi<br><br>Take a look also on Londiste from SkyTools. It is easy to set up
and manage. In addition SkyTools contains other useful scripts and
tools.<br>We use Londiste to replicate data ovwe WAN where wal****pping
would consume too much bandwidth.<br>
<br>Asko<br><br><div class="gmail_quote">On Tue, Jun 24, 2008 at 9:41 AM,
Adrian Moisey &lt;<a
href="mailto:adrian@[EMAIL PROTECTED]
">adrian@[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;">
Hi<br>
<br>
We have a 100GB database (16GB dumped) running on 8.2.<br>
<br>
Since the bandwidth in South Africa isn&#39;t that freely available it is
difficult for us to get a new copy of out DB in our office (our fastest
link in the office is 4Mbps).<br>
<br>
What can you recommend for me to get an up to date copy of my DB in the
office with as little transfer as possible.<br>
<br>
A few ideas I&#39;ve been toying with are rsyncing a dump of the db, or
replication.<br>
<br>
Any ideas?<br>
<br>
-- <br>
Adrian Moisey<br>
Systems Administrator | CareerJunction | Your Future Starts Here.<br>
Web: <a href="http://www.careerjunction.co.za"
target="_blank">www.careerjunction.co.za</a> | Email: <a
href="mailto:adrian@[EMAIL PROTECTED]
"
target="_blank">adrian@[EMAIL PROTECTED]
><br>
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686
6842<br><font color="#888888">
<br>
-- <br>
Sent via pgsql-general mailing list (<a
href="mailto:pgsql-general@[EMAIL PROTECTED]
"
target="_blank">pgsql-general@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-general"
target="_blank">http://www.postgresql.org/mailpref/pgsql-general</a><br>
</font></blockquote></div><br>

------=_Part_21253_29834405.1214374827090--
 




 1 Posts in Topic:
Re: replication
ascoja@[EMAIL PROTECTED]   2008-06-25 09:20:27 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 16:41:01 CST 2008.