Обсуждение: slony question
Hi,
Does slony support postgres major version upgrade ? ie., will it replicate between different major versions?
Thanks
josh
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
josh
On Dec 10, 2007 12:37 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1Yes. But for further questions on Slony please see the slony lists:
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?
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-----
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
./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
On Dec 10, 2007 8:19 PM, Geoffrey <lists@serioustechnology.com> wrote:
Scott Marlowe wrote:Not according to the docs:
> 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.
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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
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.