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

* Database replication ?
@ 2000-06-16 07:48  Loïc TREGOUËT <loic@ext.cri74.org>
  0 siblings, 1 reply; 8+ messages in thread

From: Loïc TREGOUËT @ 2000-06-16 07:48 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

    Hello ,

    I was talking about PostgreSQL with one of my friend who use SQL Server
.
He ask me what about replication database in Postgresql .

Is there a way to do this :
- when a row is inserted (or deleted ...) in database1 - > automatically
the same operation is replicated on a other databse

Or a dump is necessary ?


SQL server do this internally .   Thanks for your responses and don't worry
, I stay a PostgreSQL admirator .



loic@cri74.org




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

* Re: Database replication ?
@ 2000-06-16 08:30  Haroldo Stenger <hstenger@adinet.com.uy>
  parent: Loïc TREGOUËT <loic@ext.cri74.org>
  0 siblings, 1 reply; 8+ messages in thread

From: Haroldo Stenger @ 2000-06-16 08:30 UTC (permalink / raw)
  To: Loïc TREGOUËT <loic@ext.cri74.org>; pgsql-admin

Loïc TREGOUËT wrote:
> 
>     Hello ,
> 
>     I was talking about PostgreSQL with one of my friend who use SQL Server
> .
> He ask me what about replication database in Postgresql .
> 
> Is there a way to do this :
> - when a row is inserted (or deleted ...) in database1 - > automatically
> the same operation is replicated on a other databse
> 
> Or a dump is necessary ?
> 
> SQL server do this internally .   Thanks for your responses and don't worry
> , I stay a PostgreSQL admirator .
> 
> loic@cri74.org

In the TODO file, under

EXOTIC FEATURES

* Add replication of distributed databases

Besides this, I wonder if db replication could be done by reaplying backend
logs.

Regards,
Haroldo.

-- 
----------------------+------------------------
 Haroldo Stenger      | hstenger@ieee.org
 Montevideo, Uruguay. | hstenger@adinet.com.uy
----------------------+------------------------
 Visit UYLUG Web Site: http://www.linux.org.uy
-----------------------------------------------



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

* Re: Database replication ?
@ 2000-06-18 14:16  Peter Eisentraut <peter_e@gmx.net>
  parent: Haroldo Stenger <hstenger@adinet.com.uy>
  0 siblings, 0 replies; 8+ messages in thread

From: Peter Eisentraut @ 2000-06-18 14:16 UTC (permalink / raw)
  To: hstenger@ieee.org; +Cc: Loïc TREGOUËT <loic@ext.cri74.org>; pgsql-admin

Haroldo Stenger writes:

> Besides this, I wonder if db replication could be done by reaplying
> backend logs.

Yup, if we only had backend logs...


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden




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

* database replication
@ 2006-01-25 18:05  Ciprian Hodorogea <ciprian.hodorogea@bitsp.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Ciprian Hodorogea @ 2006-01-25 18:05 UTC (permalink / raw)
  To: pgsql-admin

Hi All,

 

  Is there a stable solution for database replication with Postgres 8.1.x?

 

Thanks

 

Best Regards

 

Ciprian Hodorogea

IntelliSoft SRL

http://www.bitsp.com/ 

 

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

* Re: database replication
@ 2006-01-25 19:28  Chris Browne <cbbrowne@acm.org>
  parent: Ciprian Hodorogea <ciprian.hodorogea@bitsp.com>
  0 siblings, 0 replies; 8+ messages in thread

From: Chris Browne @ 2006-01-25 19:28 UTC (permalink / raw)
  To: pgsql-admin

ciprian.hodorogea@bitsp.com ("Ciprian Hodorogea") writes:
> :o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word"
> xmlns="http://www.w3.org/TR/REC-html40";
>
> Hi All,:p>
>
> :p> 
>
>   Is there a stable solution for database replication with Postgres 8.1.x?:p>

Slony-I 1.1.5 should be released later today ;-).
-- 
"cbbrowne","@","ntlug.org"
http://cbbrowne.com/info/slony.html
"If you were plowing a field, which  would you rather use?  Two strong
oxen or 1024 chickens?"  -- Seymour Cray



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

* Database replication.
@ 2007-04-06 09:09  Dominik Żyła <dominik.zyla@gmail.com>
  0 siblings, 2 replies; 8+ messages in thread

From: Dominik Żyła @ 2007-04-06 09:09 UTC (permalink / raw)
  To: pgsql-admin

Hi!
I need to make database synchronization. I know slone-i to deal with it, but
I need real time replication, without any trigers with db structure setup.
Can someone recommend me some alternative for slone-i? It can be some
commercial stuff too.

Thanks a lot.

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

* Re: Database replication.
@ 2007-04-06 16:26  Joshua D. Drake <jd@commandprompt.com>
  parent: Dominik Żyła <dominik.zyla@gmail.com>
  1 sibling, 0 replies; 8+ messages in thread

From: Joshua D. Drake @ 2007-04-06 16:26 UTC (permalink / raw)
  To: Dominik Żyła <dominik.zyla@gmail.com>; +Cc: pgsql-admin

Dominik Żyła wrote:
> Hi!
> I need to make database synchronization. I know slone-i to deal with it, 
> but I need real time replication, without any trigers with db structure 
> setup. Can someone recommend me some alternative for slone-i? It can be 
> some commercial stuff too.

Well if you want real-time, in which I assume you mean "sync" versus 
"async" I suggest you look at a hardware based solution or other means.
There are no production sync based replication systems for PostgreSQL.

Joshua D. Drake


> 
> Thanks a lot.


-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/





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

* Re: Database replication.
@ 2007-04-15 19:29  Rodrigo Campos <rodrigocc@gmail.com>
  parent: Dominik Żyła <dominik.zyla@gmail.com>
  1 sibling, 0 replies; 8+ messages in thread

From: Rodrigo Campos @ 2007-04-15 19:29 UTC (permalink / raw)
  To: Dominik Żyła <dominik.zyla@gmail.com>; +Cc: pgsql-admin

On 4/6/07, Dominik Żyła <dominik.zyla@gmail.com> wrote:
> Hi!
> I need to make database synchronization. I know slone-i to deal with it, but
> I need real time replication, without any trigers with db structure setup.
> Can someone recommend me some alternative for slone-i? It can be some
> commercial stuff too.

You could use drbd and drbdlinks to achive this. Drbd it's like raid1
over tcp/ip, so if you put your "/var/lib/postgresql" into the drbd
partition, it would be replicated to the other machine, and so your
database.
Here is a howto[1] doing this, but test and tweak for permormance

[1] http://people.equars.com/2007/3/16/postgresql-drbdlinks-heartbeat-on-debian


> Thanks a lot.

Your are welcome, hope it was useful :)

Rodrigo


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


end of thread, other threads:[~2007-04-15 19:29 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-16 07:48 Database replication ? Loïc TREGOUËT <loic@ext.cri74.org>
2000-06-16 08:30 ` Haroldo Stenger <hstenger@adinet.com.uy>
2000-06-18 14:16   ` Peter Eisentraut <peter_e@gmx.net>
2006-01-25 18:05 database replication Ciprian Hodorogea <ciprian.hodorogea@bitsp.com>
2006-01-25 19:28 ` Re: database replication Chris Browne <cbbrowne@acm.org>
2007-04-06 09:09 Database replication. Dominik Żyła <dominik.zyla@gmail.com>
2007-04-06 16:26 ` Re: Database replication. Joshua D. Drake <jd@commandprompt.com>
2007-04-15 19:29 ` Re: Database replication. Rodrigo Campos <rodrigocc@gmail.com>

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