pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL replication solution?
4+ messages / 3 participants
[nested] [flat]

* PostgreSQL replication solution?
@ 2005-04-12 06:48 Andrei Bintintan <klodoma@ar-sd.net>
  2005-04-12 12:29 ` Re: PostgreSQL replication solution? John DeSoi <desoi@pgedit.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Andrei Bintintan @ 2005-04-12 06:48 UTC (permalink / raw)
  To: pgsql-admin

Hi to all, 

I have to do a database replication (of corse pgsql database) and I never done something like this. I still read about ...  what replication is. 

Can anyone send me some directions, documentation, ideeas, solutions? 

Thanks. 
Andy.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PostgreSQL replication solution?
  2005-04-12 06:48 PostgreSQL replication solution? Andrei Bintintan <klodoma@ar-sd.net>
@ 2005-04-12 12:29 ` John DeSoi <desoi@pgedit.com>
  2005-04-12 16:39   ` Re: PostgreSQL replication solution? Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 4+ messages in thread

From: John DeSoi @ 2005-04-12 12:29 UTC (permalink / raw)
  To: Andrei Bintintan <klodoma@ar-sd.net>; +Cc: pgsql-admin


On Apr 12, 2005, at 2:48 AM, Andrei Bintintan wrote:

>
> I have to do a database replication (of corse pgsql database) and I 
> never done something like this. I still read about ...  what 
> replication is.
>   
> Can anyone send me some directions, documentation, ideeas, solutions?

Here is a nice article on Slony:

http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PostgreSQL replication solution?
  2005-04-12 06:48 PostgreSQL replication solution? Andrei Bintintan <klodoma@ar-sd.net>
  2005-04-12 12:29 ` Re: PostgreSQL replication solution? John DeSoi <desoi@pgedit.com>
@ 2005-04-12 16:39   ` Joshua D. Drake <jd@commandprompt.com>
  2005-04-14 09:32     ` Re: PostgreSQL replication solution? Andrei Bintintan <klodoma@ar-sd.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Joshua D. Drake @ 2005-04-12 16:39 UTC (permalink / raw)
  To: John DeSoi <desoi@pgedit.com>; +Cc: Andrei Bintintan <klodoma@ar-sd.net>; pgsql-admin

John DeSoi wrote:

>
> On Apr 12, 2005, at 2:48 AM, Andrei Bintintan wrote:
>
>>
>> I have to do a database replication (of corse pgsql database) and I 
>> never done something like this. I still read about ...  what 
>> replication is.
>>   
>> Can anyone send me some directions, documentation, ideeas, solutions?
>
>
> Here is a nice article on Slony:
>
> http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html

You can also look at replicator over at http://www.commandprompt.com/ . 
It is simpler to setup than slony but it is not free.

Sincerely,

Joshua D. Drake







^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PostgreSQL replication solution?
  2005-04-12 06:48 PostgreSQL replication solution? Andrei Bintintan <klodoma@ar-sd.net>
  2005-04-12 12:29 ` Re: PostgreSQL replication solution? John DeSoi <desoi@pgedit.com>
  2005-04-12 16:39   ` Re: PostgreSQL replication solution? Joshua D. Drake <jd@commandprompt.com>
@ 2005-04-14 09:32     ` Andrei Bintintan <klodoma@ar-sd.net>
  0 siblings, 0 replies; 4+ messages in thread

From: Andrei Bintintan @ 2005-04-14 09:32 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; John DeSoi <desoi@pgedit.com>; +Cc: pgsql-admin

The scenario is the following:
I have a main database on a server probably this will be the master.

With this replication we want first to make a copy of this database which 
will be at another location(another company) with 1 time/day sincronization, 
so this will be a slave which will contain a part of the database(so not all 
the tables) ~ asyncronus replication

and

we also would like to make a backup server in our local LAN which will 
contain a complete backup of the main database in case of the server fail.

We would like a free solution if possible,
I read about Slony, what about erserver? http://www.pgsql.com/download/ or
http://gborg.postgresql.org/project/erserver/projdisplay.php

Did anyone used it? Which is better to use?

Thanks for any tipps.
Andy.


----- Original Message ----- 
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "John DeSoi" <desoi@pgedit.com>
Cc: "Andrei Bintintan" <klodoma@ar-sd.net>; <pgsql-admin@postgresql.org>
Sent: Tuesday, April 12, 2005 7:39 PM
Subject: Re: [ADMIN] PostgreSQL replication solution?


> John DeSoi wrote:
>
>>
>> On Apr 12, 2005, at 2:48 AM, Andrei Bintintan wrote:
>>
>>>
>>> I have to do a database replication (of corse pgsql database) and I 
>>> never done something like this. I still read about ...  what replication 
>>> is.
>>>   Can anyone send me some directions, documentation, ideeas, solutions?
>>
>>
>> Here is a nice article on Slony:
>>
>> http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html
>
> You can also look at replicator over at http://www.commandprompt.com/ . It 
> is simpler to setup than slony but it is not free.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
>
> 





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-04-14 09:32 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-12 06:48 PostgreSQL replication solution? Andrei Bintintan <klodoma@ar-sd.net>
2005-04-12 12:29 ` John DeSoi <desoi@pgedit.com>
2005-04-12 16:39   ` Joshua D. Drake <jd@commandprompt.com>
2005-04-14 09:32     ` Andrei Bintintan <klodoma@ar-sd.net>

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