Postgresql-8.2 Replication

On 05/10/2011 09:46, khizer wrote:

Hi,

Kindly requesting u to send the steps to set up the Postgresql-8.2
database replication.

8.2 doesn't have built-in replication - you'll need to use Slony or one
of the other tools. See the docs for suggestions:

http://www.postgresql.org/docs/8.2/static/high-availability.html

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 05/10/2011 11:19, khizer wrote:

Thanks for reply

Can we use slony on ubuntu OS
as it was giving error while compiling and installing slony

Please keep your replies on the list.

What errors were you getting? If I recall correctly, you need to have
the headers for PostgreSQL on the machine where you're building Slony.
Anyway, if you post your errors here others may be able to help you.

one more thing there is no package for slony8.2 isn't it

I don't know - 8.2 is getting old now, so maybe. It probably depends on
what version of Ubuntu you're using.

Ray.

So any other steps to Replicate postgresql8.2 databse on ubuntu

On 10/05/2011 03:44 PM, Raymond O'Donnell wrote:

On 05/10/2011 09:46, khizer wrote:

Hi,

Kindly requesting u to send the steps to set up the Postgresql-8.2
database replication.

8.2 doesn't have built-in replication - you'll need to use Slony or one
of the other tools. See the docs for suggestions:

http://www.postgresql.org/docs/8.2/static/high-availability.html

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 05/10/2011 12:04, khizer wrote:

Raymond i have attached the error file as above.

You really should keep your replies on the list - some of the many
experts on the list may be able to help you.

I'm out of my depth on this one, but the error message looks to me as if
you're missing the PostgreSQL header files, as suggested in my last
email. If you post the output to the list, someone else will be able to
say for sure.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 05/10/2011 12:24, khizer wrote:

ok Thank u

but as i am new bie i am not aware abour mailing list of postgresql

:-)

But that's what you emailed to originally - the general mailing list for
PostgreSQL. See here:

http://www.postgresql.org/community/lists

Make sure you do "Reply-all", so that your replies go to the list as
well as to the person who replied to you; that way everyone subscribed
to the list sees them, and is in a position to help you.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

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

On Wed, Oct 5, 2011 at 10:41 PM, khizer <khizer@srishtisoft.com> wrote:

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

So does the make finish? Does sudo make install then work?