Re: [Slony1-general] Postgresql-8.2 replication

[khizer]

I am using slony 1.2.22 i tried with 1.2.9 also but same problem exist  
is it related some headers.

i have attached the error file as above


On 10/11/2011 08:50 PM, Scott Marlowe wrote:
2011/10/11 khizer<khi...@srishtisoft.com>:
I am using slony 1.2.*  for postgresql-8.2
Which exact version are you trying to use?


***mehdi***@**mehdi-desktop**:~$ pg_config
BINDIR = /usr/lib/postgresql/8.2/bin
DOCDIR = /usr/share/doc/postgresql-doc-8.2
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/8.2/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql/8.2/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/8.2/man
SHAREDIR = /usr/share/postgresql/8.2
SYSCONFDIR = /etc/postgresql
PGXS = /usr/lib/postgresql/8.2/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--build=x86_64-linux-gnu' '--prefix=/usr' 
'--includedir=/usr/include' '--mandir=/usr/share/man' 
'--infodir=/usr/share/info' '--sysconfdir=/etc' '--localstatedir=/var' 
'--libexecdir=/usr/lib/postgresql-8.2' '--disable-maintainer-mode' 
'--disable-dependency-tracking' '--srcdir=.' 
'--mandir=/usr/share/postgresql/8.2/man' 
'--with-docdir=/usr/share/doc/postgresql-doc-8.2' 
'--datadir=/usr/share/postgresql/8.2' '--bindir=/usr/lib/postgresql/8.2/bin' 
'--includedir=/usr/include/postgresql/' '--enable-nls' 
'--enable-integer-datetimes' '--enable-thread-safety' '--enable-debug' 
'--disable-rpath' '--with-tcl' '--with-perl' '--with-python' '--with-pam' 
'--with-krb5' '--with-openssl' '--with-gnu-ld' 
'--with-tclconfig=/usr/lib/tcl8.4' '--with-tkconfig=/usr/lib/tk8.4' 
'--with-includes=/usr/include/tcl8.4' '--with-pgport=5432' 'CFLAGS=-g -O2 -g 
-Wall -O2 -fPIC' 'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,--as-needed' 'CC=cc' 
'CPPFLAGS=' 'build_alias=x86_64-linux-gnu'
CC = cc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/tcl8.4
CFLAGS = -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith 
-Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing 
-fwrapv -g
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-Bsymbolic-functions -Wl,--as-needed
LDFLAGS_SL = 
LIBS = -lpgport -lpam -lssl -lcrypto -lkrb5 -lcom_err -lz -lreadline -lcrypt 
-ldl -lm 
VERSION = PostgreSQL 8.2.7




***root***@**mehdi-desktop**:~/slony/slony1-1.2.22# ./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/


checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking which template to use... linux
configure: using CFLAGS=
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables... 
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for perl... /usr/bin/perl
checking for tar... /bin/tar
checking for flex... no
checking for ,... no
checking for lex... no
checking for bison... bison -y
checking for sed... sed
checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no
checking whether pthreads work with -pthread... yes
checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
checking if more special flags are required for pthreads... no
checking for cc_r... gcc
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking limits.h usability... yes
checking limits.h presence... yes
checking for limits.h... yes
checking stddef.h usability... yes
checking stddef.h presence... yes
checking for stddef.h... yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking for inttypes.h... (cached) yes
checking for gettimeofday... yes
checking for dup2... yes
checking for alarm... yes
checking for memset... yes
checking for select... yes
checking for strdup... yes
checking for strerror... yes
checking for strtol... yes
checking for strtoul... yes
checking for int32_t... yes
checking for uint32_t... yes
checking for u_int32_t... yes
checking for int64_t... yes
checking for uint64_t... yes
checking for u_int64_t... yes
checking for ssize_t... yes
checking for POSIX signal interface... yes
checking if you have requested slony1-engine building... yes
overriding pgpkglibdir with /usr/lib/postgresql/8.2/lib
overriding pgsharedir with /usr/share/postgresql/8.2/
checking for pg_config... /usr/lib/postgresql/8.2/bin//pg_config
pg_config says pg_bindir is /usr/lib/postgresql/8.2/bin/
pg_config says pg_libdir is /usr/lib/
pg_config says pg_includedir is /usr/include/postgresql/
pg_config says pg_includeserverdir is /usr/include/postgresql/8.2/server/
checking for correct version of PostgreSQL... 8.2
checking for PQunescapeBytea in -lpq... yes
checking libpq-fe.h usability... yes
checking libpq-fe.h presence... yes
checking for libpq-fe.h... yes
checking postgres.h usability... yes
checking postgres.h presence... yes
checking for postgres.h... yes
checking for utils/typcache.h... no
checking for plpgsql.so... skipped due to override
checking for postgresql.conf.sample... skipped due to override
checking for PQputCopyData in -lpq... yes
checking for PQsetNoticeReceiver in -lpq... yes
checking for PQfreemem in -lpq... yes
checking for ScanKeywordLookup... yes, and it takes  arguments
checking for typenameTypeId... checking for typenameTypeId... no
checking for GetActiveSnapshot... no
checking for ScanKeywordLookup... no
checking for standard_conforming_strings... yes
checking whether GetTopTransactionId is declared... yes
checking for DBI::Pg... checking if you have requested documentation 
building... no
configure: creating ./config.status
config.status: creating Makefile.global
config.status: creating GNUmakefile
config.status: creating postgresql-slony1.spec
config.status: creating Makefile.port
config.status: creating config.h
config.status: config.h is unchanged


***root***@**mehdi-desktop**:~/slony/slony1-1.2.22# 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 

make[1]: Entering directory `/home/mehdi/slony/slony1-1.2.22/src'
make[2]: Entering directory `/home/mehdi/slony/slony1-1.2.22/src/xxid'
gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I../.. 
-I/usr/include/postgresql/ -I/usr/include/postgresql/8.2/server/  -c -o xxid.o 
xxid.c
make[2]: Leaving directory `/home/mehdi/slony/slony1-1.2.22/src/xxid'
make[1]: Leaving directory `/home/mehdi/slony/slony1-1.2.22/src'
~                                                                      
_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general