pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwhich slony to start?
6+ messages / 4 participants
[nested] [flat]
* which slony to start?
@ 2014-06-04 20:22 wambacher <wnordmann@gmx.de>
0 siblings, 2 replies; 6+ messages in thread
From: wambacher @ 2014-06-04 20:22 UTC (permalink / raw)
To: pgsql-admin
Hi
i'm plannig to use Slony to do some replication between 2 Ubuntu-Systems
running postgresql 9.1 and 9.3.
reading this page http://slony.info/ i'm a little bit confused which
slony-version would be the best to start with.
2.2.2 , 2.1.4 or 2.0.8?
It's a production system but not for commercial (critical) use. Just an
OpenStreetmap database of ~600GB
regards
walter
--
View this message in context: http://postgresql.1045698.n5.nabble.com/which-slony-to-start-tp5806072.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: which slony to start?
@ 2014-06-04 21:12 Scott Whitney <scott@journyx.com>
parent: wambacher <wnordmann@gmx.de>
1 sibling, 1 reply; 6+ messages in thread
From: Scott Whitney @ 2014-06-04 21:12 UTC (permalink / raw)
To: wambacher <wnordmann@gmx.de>; pgsql-admin
If it's "not production," (and I understand all the nuances of "sort of production") why not just 9.3 both of them and use built-in replication? What are you trying to accomplish that you feel Slony will do better?
<div>-------- Original message --------</div><div>From: wambacher <wnordmann@gmx.de> </div><div>Date:06/04/2014 3:24 PM (GMT-06:00) </div><div>To: pgsql-admin@postgresql.org </div><div>Subject: [ADMIN] which slony to start? </div><div>
</div>Hi
i'm plannig to use Slony to do some replication between 2 Ubuntu-Systems
running postgresql 9.1 and 9.3.
reading this page http://slony.info/ i'm a little bit confused which
slony-version would be the best to start with.
2.2.2 , 2.1.4 or 2.0.8?
It's a production system but not for commercial (critical) use. Just an
OpenStreetmap database of ~600GB
regards
walter
--
View this message in context: http://postgresql.1045698.n5.nabble.com/which-slony-to-start-tp5806072.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: which slony to start?
@ 2014-06-04 21:49 wambacher <wnordmann@gmx.de>
parent: Scott Whitney <scott@journyx.com>
0 siblings, 1 reply; 6+ messages in thread
From: wambacher @ 2014-06-04 21:49 UTC (permalink / raw)
To: pgsql-admin
Scott Whitney-3 wrote
> If it's "not production," (and I understand all the nuances of "sort of
> production") why not just 9.3 both of them and use built-in replication?
> What are you trying to accomplish that you feel Slony will do better?
Ok, it's not for commercial use (no company loosing money if it fails), but
i have to do this tasks and would like to have the database online as long
as possible.
- move the database to another system
- reinstall the old system starting from scatch (ubuntu and all apps
including postgresql/postgis)
- upgrade from 9.1 to 9.3
my plan: install 9.3 on new system, move database using slony, reinstall new
system with 9.3, move database back, keep slony alive for fallback. i will
not upgrade the running server to 9.3 without fallback.
ok, you say "do it without slony"
than i have to install 9.1 on the new server, sync databases, rebuild old
server with 9.1, resync back, upgrade new server to 9.3, upgrade
backup-Server to 9.3
so i ask again: which version of slony should i use - if i do it with slony?
Regards
walter
--
View this message in context: http://postgresql.1045698.n5.nabble.com/which-slony-to-start-tp5806072p5806085.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: which slony to start?
@ 2014-06-04 22:01 Jeff Frost <jeff@pgexperts.com>
parent: wambacher <wnordmann@gmx.de>
0 siblings, 1 reply; 6+ messages in thread
From: Jeff Frost @ 2014-06-04 22:01 UTC (permalink / raw)
To: wambacher <wnordmann@gmx.de>; +Cc: pgsql-admin
On Jun 4, 2014, at 2:49 PM, wambacher <wnordmann@gmx.de> wrote:
> so i ask again: which version of slony should i use - if i do it with slony?
I would use 2.2.
BTW, we do have a separate mailing list for slony:
http://lists.slony.info/mailman/listinfo/slony1-general
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: which slony to start?
@ 2014-06-04 22:22 wambacher <wnordmann@gmx.de>
parent: Jeff Frost <jeff@pgexperts.com>
0 siblings, 0 replies; 6+ messages in thread
From: wambacher @ 2014-06-04 22:22 UTC (permalink / raw)
To: pgsql-admin
Jeff Frost-2 wrote
> I would use 2.2.
>
> BTW, we do have a separate mailing list for slony:
>
> http://lists.slony.info/mailman/listinfo/slony1-general
Thanks. ok 2.2 should be fine.
i know about that mailing-list (even have an account there) but i can't use
it . I prefer nabble as interface and could not find slony on nabble.
if i have technical questions about slony, i'll try to go the direct way.
Regards
walter
--
View this message in context: http://postgresql.1045698.n5.nabble.com/which-slony-to-start-tp5806072p5806094.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: which slony to start?
@ 2014-06-25 14:17 Devrim Gündüz <devrim@gunduz.org>
parent: wambacher <wnordmann@gmx.de>
1 sibling, 0 replies; 6+ messages in thread
From: Devrim Gündüz @ 2014-06-25 14:17 UTC (permalink / raw)
To: wambacher <wnordmann@gmx.de>; +Cc: pgsql-admin
Hi,
On Wed, 2014-06-04 at 13:22 -0700, wambacher wrote:
> i'm plannig to use Slony to do some replication between 2 Ubuntu-Systems
> running postgresql 9.1 and 9.3.
>
> reading this page http://slony.info/ i'm a little bit confused which
> slony-version would be the best to start with.
>
> 2.2.2 , 2.1.4 or 2.0.8?
2.2.2. per:
http://git.postgresql.org/gitweb/?p=slony1-engine.git;a=blob_plain;f=RELEASE;hb=52e6127d264662997e69...
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachments:
signature.asc (application/pgp-signature, 835B) download
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2014-06-25 14:17 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-06-04 20:22 which slony to start? wambacher <wnordmann@gmx.de>
2014-06-04 21:12 ` Scott Whitney <scott@journyx.com>
2014-06-04 21:49 ` wambacher <wnordmann@gmx.de>
2014-06-04 22:01 ` Jeff Frost <jeff@pgexperts.com>
2014-06-04 22:22 ` wambacher <wnordmann@gmx.de>
2014-06-25 14:17 ` Devrim Gündüz <devrim@gunduz.org>
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