pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase replication ?
8+ messages / 8 participants
[nested] [flat]
* Database replication ?
@ 2000-06-16 07:48 Loïc TREGOUËT <loic@ext.cri74.org>
2000-06-16 08:30 ` Re: Database replication ? Haroldo Stenger <hstenger@adinet.com.uy>
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 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 ` Re: Database replication ? Peter Eisentraut <peter_e@gmx.net>
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-16 07:48 Database replication ? Loïc TREGOUËT <loic@ext.cri74.org>
2000-06-16 08:30 ` Re: Database replication ? Haroldo Stenger <hstenger@adinet.com.uy>
@ 2000-06-18 14:16 ` Peter Eisentraut <peter_e@gmx.net>
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>
2006-01-25 19:28 ` Re: database replication Chris Browne <cbbrowne@acm.org>
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 18:05 database replication Ciprian Hodorogea <ciprian.hodorogea@bitsp.com>
@ 2006-01-25 19:28 ` Chris Browne <cbbrowne@acm.org>
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>
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>
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 09:09 Database replication. Dominik Żyła <dominik.zyla@gmail.com>
@ 2007-04-06 16:26 ` Joshua D. Drake <jd@commandprompt.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-06 09:09 Database replication. Dominik Żyła <dominik.zyla@gmail.com>
@ 2007-04-15 19:29 ` Rodrigo Campos <rodrigocc@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