I am using slony 1.2.*  for postgresql-8.2

Ru aware of any other method of replication for postgresql-8.2

On 10/11/2011 07:21 PM, Devrim GÜNDÜZ wrote:
> I don't think that Slony 2.X will work against PostgreSQL 8.2. You need
> to use 1.2.X.
>
> That said, PostgreSQL 8.2 will be EOLed by the end of this year, or so.
>
> Regards,
> Devrim
>
> On Tue, 2011-10-11 at 15:16 +0530, khizer wrote:
>> Hi,
>>
>> I am trying to compile and install slony in ubuntu OS 10.10
>>
>> i tried with the command
>> ./configure --prefix=/usr/lib/postgresql/8.2/bin/
>> --with-pgconfigdir=/usr/lib/postgresql/8.2/bin/
>> --with-perltools=/usr/lib/postgresql/8.2/bin/
>> --with-pgpkglibdir=/usr/lib/postgresql/8.2/lib/
>> --with-pgsharedir=/usr/share/postgresql/8.2/
>> --with-pgincludedir=/usr/include/postgresql
>> --with-pgincludeserverdir=/usr/include/postgresql/8.2/server
>>
>> but i am getting error as follow while running
>> make
>>
>>
>> from xxid.c:20:
>> /usr/include/postgresql/8.2/server/tcop/tcopprot.h:30:18: error:
>> expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘const’
>> In file included from
>> /usr/include/postgresql/8.2/server/executor/spi.h:37:0,
>> from xxid.c:20:
>> /usr/include/postgresql/8.2/server/utils/builtins.h:260:18: error:
>> expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘int’
>> In file included from xxid.c:20:0:
>> /usr/include/postgresql/8.2/server/executor/spi.h:78:18: error: expected
>> ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘uint32’
>> /usr/include/postgresql/8.2/server/executor/spi.h:79:18: error: expected
>> ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘Oid’
>> /usr/include/postgresql/8.2/server/executor/spi.h:80:18: error: expected
>> ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘SPITupleTable’
>> /usr/include/postgresql/8.2/server/executor/spi.h:81:18: error: expected
>> ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘int’
>> xxid.c:26:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:26:1: warning: no previous prototype for ‘Pg_magic_func’
>> xxid.c:31:0: warning: "SET_VARSIZE" redefined
>> /usr/include/postgresql/postgres.h:260:0: note: this is the location of
>> the previous definition
>> xxid.c:52:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:52:1: warning: no previous prototype for ‘pg_finfo__Slony_I_xxidin’
>> xxid.c:53:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:53:1: warning: no previous prototype for ‘pg_finfo__Slony_I_xxidout’
>> xxid.c:54:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:54:1: warning: no previous prototype for ‘pg_finfo__Slony_I_xxideq’
>> xxid.c:55:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:55:1: warning: no previous prototype for ‘pg_finfo__Slony_I_xxidne’
>> xxid.c:56:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:56:1: warning: no previous prototype for ‘pg_finfo__Slony_I_xxidlt’
>> xxid.c:57:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:57:1: warning: no previous prototype for ‘pg_finfo__Slony_I_xxidle’
>> xxid.c:58:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:58:1: warning: no previous prototype for ‘pg_finfo__Slony_I_xxidgt’
>> xxid.c:59:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:59:1: warning: no previous prototype for ‘pg_finfo__Slony_I_xxidge’
>> xxid.c:60:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:60:1: warning: no previous prototype for
>> ‘pg_finfo__Slony_I_btxxidcmp’
>> xxid.c:61:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:61:1: warning: no previous prototype for
>> ‘pg_finfo__Slony_I_getCurrentXid’
>> xxid.c:62:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:62:1: warning: no previous prototype for
>> ‘pg_finfo__Slony_I_getMinXid’
>> xxid.c:63:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:63:1: warning: no previous prototype for
>> ‘pg_finfo__Slony_I_getMaxXid’
>> xxid.c:77:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:77:1: warning: no previous prototype for
>> ‘pg_finfo__Slony_I_xxid_snapshot_in’
>> xxid.c:78:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:78:1: warning: no previous prototype for
>> ‘pg_finfo__Slony_I_xxid_snapshot_out’
>> xxid.c:79:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:79:1: warning: no previous prototype for
>> ‘pg_finfo__Slony_I_xxid_lt_snapshot’
>> xxid.c:80:1: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
>> before ‘const’
>> xxid.c:80:1: warning: no previous prototype for
>> ‘pg_finfo__Slony_I_xxid_ge_snapshot’
>> xxid.c: In function ‘_Slony_I_getMinXid’:
>> xxid.c:243:6: error: ‘SerializableSnapshot’ undeclared (first use in
>> this function)
>> xxid.c:243:6: note: each undeclared identifier is reported only once for
>> each function it appears in
>> xxid.c: In function ‘_Slony_I_getMaxXid’:
>> xxid.c:259:6: error: ‘SerializableSnapshot’ undeclared (first use in
>> this function)
>> xxid.c: In function ‘_Slony_I_xxid_snapshot_in’:
>> xxid.c:337:2: warning: implicit declaration of function ‘VARATT_SIZEP’
>> xxid.c:337:2: error: lvalue required as left operand of assignment
>> xxid.c: In function ‘_Slony_I_getMaxXid’:
>> xxid.c:263:1: warning: control reaches end of non-void function
>> xxid.c: In function ‘_Slony_I_getMinXid’:
>> xxid.c:247:1: warning: control reaches end of non-void function
>> make[2]: *** [xxid.o] Error 1
>> make[2]: Leaving directory `/home/karthika/slony1-1.2.22/src/xxid'
>> make[1]: *** [all] Error 2
>> make[1]: Leaving directory `/home/karthika/slony1-1.2.22/src'
>> make: *** [all] Error 2
>>
>>
>>
>> Mehdi
>>
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
>