pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bill Montgomery <billm@lulu.com>
To: Rodrigo Botana <rodrigo_botana@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Replication
Date: Tue, 10 Aug 2004 11:10:19 -0400
Message-ID: <4118E55B.20002@lulu.com> (raw)
In-Reply-To: <BAY9-DAV32AI3F5Y0Zw0003b77e@hotmail.com>
References: <BAY9-DAV32AI3F5Y0Zw0003b77e@hotmail.com>

Rodrigo,

Rodrigo Botana wrote:

> There is any way to have a replication (master -> slave) whithout 
> install anything on the slave computer. I ask this because i would 
> like to have my website (that don't have any replication service 
> avaliable) with the same information of my internal system.


In theory, the slon daemon of Slony-I (http://slony.info/) can be run on 
a separate machine from the database to which it connects (it just uses 
a libpq connection). With this technique, you could run the website's 
slon daemon on your local box, along with the slon daemon for the 
"master" database. YMMV on how well it works with the slon-->postmaster 
connection over a WAN (it is typically over a local socket).

Depending on your requirements, however, Slony may be overkill. What is 
the size of your data set? How many seconds/minutes/hours/days can your 
website afford to be out of sync with the data on your internal system? 
If you could be as much as say, a day out of date, and your data set is 
less than 100MB, and you have a pretty fast connection between your 
internal system and the website, you might get away with a nightly 
pg_dump, piped to a psql process that connects to the pgsql server on 
your website.

There are many ways to skin the replication cat, and the right one 
depends on your requirements. There is no one universal solution that's 
appropriate for everyone, but with more information, we could be of 
better help.

Best Regards,

Bill Montgomery



view thread (63+ messages)  latest in thread

Message-ID: <4118E55B.20002@lulu.com>
Permalink:  ../4118E55B.20002@lulu.com/
Also on:    postgresql.org/message-id/4118E55B.20002@lulu.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: billm@lulu.com, rodrigo_botana@hotmail.com
  Subject: Re: Replication
  In-Reply-To: <4118E55B.20002@lulu.com>
  References: <BAY9-DAV32AI3F5Y0Zw0003b77e@hotmail.com> <4118E55B.20002@lulu.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox