Fwd: Postgresql-8.2 Replication - Mailing list pgsql-general

Hi Experts,


I want to set Master Slave replication of a database on Ubuntu 10.10
  So kindly requesting u to send  the instructions.

Please waiting for your valuable responses

I tried to compile and install slony but i am getting error for
installation as follows;


***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

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'
~




Mehdi