Обсуждение: slony question

Hi,
Does slony support postgres major version upgrade ? ie., will it replicate between different major versions?
Thanks
josh

On 10/12/2007 17:20, Josh Harrison wrote:

> Does slony support postgres major version upgrade ? ie., will it
> replicate between different major versions?

You'll get a more definitive answer on the Slony list, but I think so -
IIRC that's one of Slony's /raisons d'etre/.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 10 Dec 2007 12:20:07 -0500
"Josh Harrison" <joshques@gmail.com> wrote:

> Hi,
> Does slony support postgres major version upgrade ? ie., will it
> replicate between different major versions?

Yes. But for further questions on Slony please see the slony lists:

http://lists.slony.info/mailman/listinfo

Sincerely,

Joshua D. Drake

> Thanks
> josh


- -- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHXXlfATb/zqfZUUQRAn5jAJ9iounFrKiLUSv/Eo5c4KaBZl5QRQCgogOV
5On/T8c/7xMFQ6UrvPpMhpE=
=4gk8
-----END PGP SIGNATURE-----

Thanks...Ill check that list
josh

joshques@gmail.com ("Josh Harrison") writes:
> Does slony support postgres major version upgrade ? ie., will it
> replicate between different major versions?

Yes, that's one of the major "use cases" for Slony-I.

Version 1.0 and 1.1 support (loosely) from PostgreSQL 7.3 to 8.1-ish.

Version 1.2 dropped 7.3 support, but supports up to (just about;
there's a patch not in a 1.2 release that is needed for late-breaking
8.3 changes) 8.3.

You may have to be careful about which version of Slony-I you select
if you have a really old PG database.
--
select 'cbbrowne' || '@' || 'acm.org';
http://www3.sympatico.ca/cbbrowne/lisp.html
"What you  said you   want to do  is  roughly  equivalent to   nailing
horseshoes to the tires of your Buick."  -- danceswithcrows@usa.net on
the question "Why can't Linux use Windows Drivers?"

On Dec 10, 2007 2:19 PM, Chris Browne <cbbrowne@acm.org> wrote:
> joshques@gmail.com ("Josh Harrison") writes:
> > Does slony support postgres major version upgrade ? ie., will it
> > replicate between different major versions?
>
> Yes, that's one of the major "use cases" for Slony-I.
>
> Version 1.0 and 1.1 support (loosely) from PostgreSQL 7.3 to 8.1-ish.
>
> Version 1.2 dropped 7.3 support, but supports up to (just about;
> there's a patch not in a 1.2 release that is needed for late-breaking
> 8.3 changes) 8.3.

Didn't 1.2 drop support for pg 7.4 as well?  I thought I remembered
reading that some time ago.

Scott Marlowe wrote:
> On Dec 10, 2007 2:19 PM, Chris Browne <cbbrowne@acm.org> wrote:
>> joshques@gmail.com ("Josh Harrison") writes:
>>> Does slony support postgres major version upgrade ? ie., will it
>>> replicate between different major versions?
>> Yes, that's one of the major "use cases" for Slony-I.
>>
>> Version 1.0 and 1.1 support (loosely) from PostgreSQL 7.3 to 8.1-ish.
>>
>> Version 1.2 dropped 7.3 support, but supports up to (just about;
>> there's a patch not in a 1.2 release that is needed for late-breaking
>> 8.3 changes) 8.3.
>
> Didn't 1.2 drop support for pg 7.4 as well?  I thought I remembered
> reading that some time ago.

Not according to the docs:

http://slony.info/documentation/requirements.html
Section 3.1, 3rd bullet:

You also need a recent version of PostgreSQL source. Slony-I depends on
namespace support so you must have PostgreSQL version 7.3.3 or newer to
be able to build and use Slony-I.

It says the same thing in the Slony 1.2.12 docs rpm.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

Thanks. Im testing slony1-1.2.12 in postgres 8.3beta3 version. I tried to configure slony but I keep getting this error.

 ./configure --with-pgconfigdir=/export/home/sjothirajah/postgres8.3/bin --with-enable-thread-safety
or
./configure --with-pgconfigdir=/export/home/sjothirajah/postgres8.3/bin --enable-thread-safety

........
........
checking for correct version of PostgreSQL... 8.3
pg_config says pg_sharedir is /usr4/postgres8.3/share/postgresql/
checking PostgreSQL for enable-thread-safety as required on solaris2.10... no
configure: error: PostgreSQL needs to be compiled with --enable-thread-safety on solaris2.10

Can you help
Thanks
josh

scott.marlowe@gmail.com ("Scott Marlowe") writes:
> On Dec 10, 2007 2:19 PM, Chris Browne <cbbrowne@acm.org> wrote:
>> joshques@gmail.com ("Josh Harrison") writes:
>> > Does slony support postgres major version upgrade ? ie., will it
>> > replicate between different major versions?
>>
>> Yes, that's one of the major "use cases" for Slony-I.
>>
>> Version 1.0 and 1.1 support (loosely) from PostgreSQL 7.3 to 8.1-ish.
>>
>> Version 1.2 dropped 7.3 support, but supports up to (just about;
>> there's a patch not in a 1.2 release that is needed for late-breaking
>> 8.3 changes) 8.3.
>
> Didn't 1.2 drop support for pg 7.4 as well?  I thought I remembered
> reading that some time ago.

Well, that would mean that some of the testing I have been continuing
to do would be pretty useless ;-).

We still have one instance of 7.4 in production, where we'll want to
migrate to 8.something in the new year.  It still seems nice to have
the option of possibly upgrading to new Slony-I before upgrading to
8.x, rather than being forced to do otherwise ;-).
--
output = reverse("ofni.sesabatadxunil" "@" "enworbbc")
http://linuxfinances.info/info/sgml.html
Change is inevitable, except from a vending machine.