Thread: which slony to start?
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.
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?
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
-------- Original message --------
From: wambacher
Date:06/04/2014 3:24 PM (GMT-06:00)
To: pgsql-admin@postgresql.org
Subject: [ADMIN] which slony to start?
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
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.
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:
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.
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=52e6127d264662997e69bf0d07f947aebf4c7c61 Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR