[postgis-users] Replication question, can I replicate a postgres/postgis 9.0/1.5 instance to a 9.1/2.0 instance?

[Basques, Bob (CI-StPaul)]

Andreas,

The question posed to me was related to different client packages needing different versions of server software in place in order to connect.  The newer clients need the newer server, where the older versions of things are already in place.  So, I was wondering about setting up a replication process.  I was specifically interested in the PostGres tools to do this.  I have another project coming up where I will be doing something similar, only with all like service versions.

Hmm, makes me wonder if anyone has thought about some sort of POSTGRES config that could answer to some number of previous versions of clients in some form or another.  Maybe there are pieces of this idea that I'm oblivious too though.

Thanks for the info.

Bobb



>>  -----Original Message-----
>>  From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-
>>  users-bounces at lists.osgeo.org] On Behalf Of Andreas Neumann
>>  Sent: Wednesday, January 09, 2013 1:18 PM
>>  To: postgis-users at lists.osgeo.org
>>  Subject: Re: [postgis-users] Replication question, can I
>>  replicate a postgres/postgis 9.0/1.5 instance to a 9.1/2.0
>>  instance?
>>  
>>  Hi,
>>  
>>  This depends on your chosen replication technology. With the
>>  builtin streaming/cascading/synchronous replication you need
>>  exactly the same versions for master and all the slaves. This is
>>  also an everything or nothing replication. These builtin
>>  replication uses the WAL file to replicate.
>>  
>>  But with other technologies (e.g. Bucardo (which is trigger
>>  based)) you can use different PostgreSQL versions. There is also
>>  pgPool, which is statement based replication.
>>  
>>  See also
>>  http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Conn
>>  ection_Pooling#Replication
>>  for alternative, not builtin, replication.
>>  
>>  Andreas
>>  
>>  Am 09.01.2013 19:49, schrieb Basques, Bob (CI-StPaul):
>>  > Subject says it all.  Possible ?
>>  >
>>  > Thanks
>>  >
>>  > Bobb
>>  >
>>  >
>>  >
>>  >
>>  >
>>  > _______________________________________________
>>  > postgis-users mailing list
>>  > postgis-users at lists.osgeo.org
>>  > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>  >
>>  
>>  _______________________________________________
>>  postgis-users mailing list
>>  postgis-users at lists.osgeo.org
>>  http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users