agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedreplication
10+ messages / 10 participants
[nested] [flat]
* replication
@ 1999-06-15 19:39 Fabio Silvestri <fabio@informatec.com.br>
0 siblings, 0 replies; 10+ messages in thread
From: Fabio Silvestri @ 1999-06-15 19:39 UTC (permalink / raw)
To: pgsql-sql
How can i do replication with postgres databases?
--
Veja tudo, aprenda tudo, naum toque em nada !
|o Fabio Silvestri
|o fabio@informatec.com.br
|o Informatec Informatica Ltda.
|o ICQ: 1667351
|o http://www.informatec.com.br
|o Tubarao - Santa Catarina - Brazil
|o +55 48 6264161
|o _ _ _ _ _ /`-'`-'
|o _ _ _ _ / `-' `-' `-' `-' `-'
`-' `-' `-' `-' `-'
" Linux on the other hand takes the best from both worlds:
System V (AT&T/East Coast) and BSD (Berkeley/West Coast). "
Remember: "Time is the best teacher; Unfortunately it kills all its
students!"
^ permalink raw reply [nested|flat] 10+ messages in thread
* replication..
@ 1999-08-26 11:14 =?iso-8859-9?Q?Safa_Pilavc=FD?= <safa.pilavci@rumeli.net>
0 siblings, 0 replies; 10+ messages in thread
From: Safa Pilavcý @ 1999-08-26 11:14 UTC (permalink / raw)
To: pgsql-sql
Hello,
Is it possible to do replication through postgresql on Solaris 2.6..?
Can you show me any adress that tells replication on postrgres..?
Thanks..
Safa Pilavcý
Rumeli Telekom A.Þ
Tel : (90) 212 288 78 50
Fax : (90) 212 274 87 21
safa.pilavci@rumeli.net
^ permalink raw reply [nested|flat] 10+ messages in thread
* Replication
@ 2001-10-18 14:59 Hunter, Ray <rhunter@enterasys.com>
2001-10-18 17:12 ` Re: Replication Josh Berkus <josh@agliodbs.com>
2001-10-18 17:33 ` Re: Replication clayton cottingham <drfrog@smartt.com>
0 siblings, 2 replies; 10+ messages in thread
From: Hunter, Ray @ 2001-10-18 14:59 UTC (permalink / raw)
To: pgsql-sql
Does Postgres in anyway support replication? Will I be able to have
load-balancing between two postgres databases?
RAY HUNTER
Automated Test Group
Software Support Engineer
ENTERASYS NETWORKS
Internal: 53888
Phone: 801 887-9888
Fax: 801 972-5789
Cellular: 801 698-0622
rhunter@enterasys.com
www.enterasys.com
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Replication
2001-10-18 14:59 Replication Hunter, Ray <rhunter@enterasys.com>
@ 2001-10-18 17:12 ` Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 10+ messages in thread
From: Josh Berkus @ 2001-10-18 17:12 UTC (permalink / raw)
To: Hunter, Ray <rhunter@enterasys.com>; pgsql-sql
Ray,
> Does Postgres in anyway support replication? Will I be able to have
> load-balancing between two postgres databases?
Not at this time. GreatBridge was working on replication when they shut
down. It's very likely that Red Hat will add replication once they get
up to speed on Postgres, but there are no definite plans.
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Replication
2001-10-18 14:59 Replication Hunter, Ray <rhunter@enterasys.com>
@ 2001-10-18 17:33 ` clayton cottingham <drfrog@smartt.com>
1 sibling, 0 replies; 10+ messages in thread
From: clayton cottingham @ 2001-10-18 17:33 UTC (permalink / raw)
To: Hunter, Ray <rhunter@enterasys.com>; +Cc: pgsql-sql
> "Hunter, Ray" wrote:
>
> Does Postgres in anyway support replication? Will I be able to have
> load-balancing between two postgres databases?
>
> RAY HUNTER
> Automated Test Group
> Software Support Engineer
>
> ENTERASYS NETWORKS
>
> Internal: 53888
> Phone: 801 887-9888
> Fax: 801 972-5789
> Cellular: 801 698-0622
>
> rhunter@enterasys.com
>
> www.enterasys.com
in the 7.1 contrib section there should be some code in there under
rserv/
good luck
^ permalink raw reply [nested|flat] 10+ messages in thread
* replication
@ 2002-01-10 22:27 Peter T. Brown <peter@memeticsystems.com>
2002-01-10 23:34 ` Re: [SQL] replication Bryan White <bryan@arcamax.com>
2002-01-10 23:35 ` Re: replication David Stanaway <david@netventures.com.au>
0 siblings, 2 replies; 10+ messages in thread
From: Peter T. Brown @ 2002-01-10 22:27 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; pgsql-sql
Hello
I want to add replication capabilities to my postgresql installation. Can
anyone recommend a good way (open source or otherwise) to do so?
Basically, I have a web tracking application that must quickly and reliably
store massive amounts of tracking data. Later, I run complex queries to
analyze this tracking data. These complex queries tend to be very resource
intensive, so I'd like to have them run on a separate machine altogether. I
need a simple and reliable method to 'copy' any data added to the tracking
database to the analysis database. Preferably, I'd be able to configure this
copy process to defer to high priority queries or to be considerate of the
time of day.
Thanks,
Peter T. Brown
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [SQL] replication
2002-01-10 22:27 replication Peter T. Brown <peter@memeticsystems.com>
@ 2002-01-10 23:34 ` Bryan White <bryan@arcamax.com>
1 sibling, 0 replies; 10+ messages in thread
From: Bryan White @ 2002-01-10 23:34 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
> I want to add replication capabilities to my postgresql installation. Can
> anyone recommend a good way (open source or otherwise) to do so?
>
> Basically, I have a web tracking application that must quickly and
reliably
> store massive amounts of tracking data. Later, I run complex queries to
> analyze this tracking data. These complex queries tend to be very resource
> intensive, so I'd like to have them run on a separate machine altogether.
I
> need a simple and reliable method to 'copy' any data added to the tracking
> database to the analysis database. Preferably, I'd be able to configure
this
> copy process to defer to high priority queries or to be considerate of the
> time of day.
How closely does the replicated data have to track your live data. I my
installation I have an cron job that runs at 2:30am daily. It backs up the
database (using pg_dump) and loads it on another machine. I can then run
queries the next day on the backup machine without hurting performance on
the primary. It also has the side effect of producing the backup file for
saving to tape or whatever. It also veryfies daily that the backup file is
not corrupt because the load would fail on the secondary machine.
This is not true replication but it might serve your needs. I looked at the
replication solutions for PostgreSQL a while ago and got the impression they
were not ready for primetime. In may have changed since then.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: replication
2002-01-10 22:27 replication Peter T. Brown <peter@memeticsystems.com>
@ 2002-01-10 23:35 ` David Stanaway <david@netventures.com.au>
1 sibling, 0 replies; 10+ messages in thread
From: David Stanaway @ 2002-01-10 23:35 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Friday, January 11, 2002, at 09:27 AM, Peter T. Brown wrote:
> Hello
>
> I want to add replication capabilities to my postgresql installation.
> Can
> anyone recommend a good way (open source or otherwise) to do so?
I read this the other day, but haven't used it (And I suspect the
document may need an update)
http://techdocs.postgresql.org/techdocs/settinguprserv.php
The document only describes replication between databases on one server
though.. Other people here probably have more experience with rserv and
can let you know what its status is.
- --
Best Regards
David Stanaway
================================
Technology Manager
Australia's Premier Internet Broadcasters
Phone: +612 9357 1699
Fax: +612 9357 1169
Web: http://www.netventures.com.au
Support: support@netventures.com.au
================================
The Inspire Foundation is proudly supported by Net Ventures through the
provision of streaming solutions for it's national centres. The Inspire
Foundation is an Internet-based foundation that inspires young people to
help themselves, get involved and get online. Please visit Inspire at
http://www.inspire.org.au
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org
iQEXAwUBPD4lSr6yIDFGeSAyFALYPQP8CuuS4pRHicYDVJSpJosJa8A9CqSxMkkd
kqsMELbPUKSfMDsRSXoRtRYGOoymKqf6bPru5TbyPJHBIGGTJMRLuPRkvqVWitK1
l3zjMWmBzrrUB7rPa0WR35YQ9jVVSEP87I3z623d+vDG8VluBG6dKMKuMgGURb76
t1po5JtLpYAD/0BLlg9zUsPrwl70Z2b8ctXF3u2Xv2m8inSr+4qtqlgYLkLsrUih
Lv9usaNXcIrY9of5v/PBNEAmY9DlN1fhjm0Zw6vTnzrlP/EDhWSdX7omAFGaBUi7
9XWuOVcrd7iqizmxzqsN+TGbodlGsEgmfMbJMwLY90gUx/t8d3aWQREj
=EbMK
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 10+ messages in thread
* Replication
@ 2016-02-03 18:46 Jürgen Purtz <juergen@purtz.de>
2016-02-03 22:59 ` Re: Replication Steve Midgley <science@misuse.org>
0 siblings, 1 reply; 10+ messages in thread
From: Jürgen Purtz @ 2016-02-03 18:46 UTC (permalink / raw)
To: pgsql-sql
Hi all,
replication is a complex topic, so I tried to get a systematic view on
it. Among others I found 4 mutually independent (?) concepts:
* Log-Shipping vs. Streaming (LS vs. S)
* Physical Format vs. Logical Decoded Format (PFo vs. LFo)
* Synchronous vs. asynchronous transfer (STr vs ASTr)
* hot standby vs. warm standby
'Mutually independent' implies that there are 2 power 4 = 16 possible
combinations. But I believe, there are some limitations.
First, hot and warm standby (at the standby site) are possible in all
cases. Second, for me the following 5 out of 8 seems to be possible:
LS - PFo - ASTr (Asynchronous Log-shipping in Physical Format)
S - PFo - STr (Synchronous Streaming in Physical Format)
S - PFo - ASTr (Asynchronous Streaming in Physical Format)
S - LFo - STr (Synchronous Streaming in Logical Format)
S - LFo - ASTr (Asynchronous Streaming in Logical Format)
My questions are:
1. Do you agree to this systematization into 4 categories?
2. Do you agree, that only this 5 out of 8 possibilities exist?
Regards
Jürgen Purtz
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Replication
2016-02-03 18:46 Replication Jürgen Purtz <juergen@purtz.de>
@ 2016-02-03 22:59 ` Steve Midgley <science@misuse.org>
0 siblings, 0 replies; 10+ messages in thread
From: Steve Midgley @ 2016-02-03 22:59 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
On Wed, Feb 3, 2016 at 10:46 AM, Jürgen Purtz <juergen@purtz.de> wrote:
> Hi all,
>
> replication is a complex topic, so I tried to get a systematic view on it.
> Among others I found 4 mutually independent (?) concepts:
>
> - Log-Shipping vs. Streaming (LS vs. S)
> - Physical Format vs. Logical Decoded Format (PFo vs. LFo)
> - Synchronous vs. asynchronous transfer (STr vs ASTr)
> - hot standby vs. warm standby
>
> My questions are:
>
> 1. Do you agree to this systematization into 4 categories?
> 2. Do you agree, that only this 5 out of 8 possibilities exist?
>
> I think you're actually asking what replication strategies Postgres
supports out of the box, and of those which are viable combinations? If so,
someone else will have to say whether your categories are comprehensive.
If you are asking about what replication strategies are possible more
broadly (and implementable with Postgres) the list gets bigger. I've messed
around with MVCC (multi-version concurrency control) and there are several
implementations out there - I looked at PouchDB <http://pouchdb.com/; in
javascript and it seemed plausible to implement on top of specifically
organized Postgres DBs. This could enable a master-master federated data
replication network with no central authority. Record collisions are
unhappy possibilities, and locking anything becomes impossible in a
meaningful way. Notable also that getting good test case coverage is pretty
hard.
But if you are trying to find strategies to replicate your data, in some
cases that's an interesting approach..
Steve
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2016-02-03 22:59 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-15 19:39 replication Fabio Silvestri <fabio@informatec.com.br>
1999-08-26 11:14 replication.. =?iso-8859-9?Q?Safa_Pilavc=FD?= <safa.pilavci@rumeli.net>
2001-10-18 14:59 Replication Hunter, Ray <rhunter@enterasys.com>
2001-10-18 17:12 ` Re: Replication Josh Berkus <josh@agliodbs.com>
2001-10-18 17:33 ` Re: Replication clayton cottingham <drfrog@smartt.com>
2002-01-10 22:27 replication Peter T. Brown <peter@memeticsystems.com>
2002-01-10 23:34 ` Bryan White <bryan@arcamax.com>
2002-01-10 23:35 ` David Stanaway <david@netventures.com.au>
2016-02-03 18:46 Replication Jürgen Purtz <juergen@purtz.de>
2016-02-03 22:59 ` Re: Replication Steve Midgley <science@misuse.org>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox