Thread: Trouble installing Slony 2.0

Trouble installing Slony 2.0

From
sparikh
Date:
I have been struggling to install slony 2.0 for past few days.

Linux server detail : Linux vmbndbdev01 2.6.32-279.el6.x86_64 #1 SMP Fri Jun
22 12:19:21 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux

I have 2 versions of postgresql installed 8.4.18 and 9.1.12, but only 9.x is
in use.

I get following errors when i issue command gmake all. I would really
appreciate if somebody can shed some light or give me some pointers.

Thanks in Advance.

[root@vmbndbdev01 slony1-2.0.0-rc1]# gmake all

gmake[1]: Entering directory `/root/slony1-2.0.0-rc1/src'
gmake[2]: Entering directory `/root/slony1-2.0.0-rc1/src/parsestatements'
./test-scanner < /dev/null > emptytestresult.log
cmp ./emptytestresult.log emptytestresult.expected
./test-scanner < ./test_sql.sql > test_sql.log
cmp ./test_sql.log ./test_sql.expected
./test-scanner < ./cstylecomments.sql > cstylecomments.log
cmp ./cstylecomments.log ./cstylecomments.expected
gmake[2]: Leaving directory `/root/slony1-2.0.0-rc1/src/parsestatements'
gmake[2]: Entering directory `/root/slony1-2.0.0-rc1/src/slon'
gmake[2]: Nothing to be done for `all'.
gmake[2]: Leaving directory `/root/slony1-2.0.0-rc1/src/slon'
gmake[2]: Entering directory `/root/slony1-2.0.0-rc1/src/slonik'
gmake[2]: Nothing to be done for `all'.
gmake[2]: Leaving directory `/root/slony1-2.0.0-rc1/src/slonik'
gmake[2]: Entering directory `/root/slony1-2.0.0-rc1/src/backend'
gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../.. -fpic
-I/usr/pgsql-9.1/include/ -I/usr/pgsql-9.1/include/server/  -c -o
slony1_funcs.o slony1_funcs.c
slony1_funcs.c: In function â_Slony_I_createEventâ:
slony1_funcs.c:137: error: âSerializableSnapshotâ undeclared (first use in
this function)
slony1_funcs.c:137: error: (Each undeclared identifier is reported only once
slony1_funcs.c:137: error: for each function it appears in.)
slony1_funcs.c: In function âslon_quote_literalâ:
slony1_funcs.c:1013: warning: pointer targets in passing argument 1 of
âpg_mblenâ differ in signedness
/usr/pgsql-9.1/include/server/mb/pg_wchar.h:399: note: expected âconst char
*â but argument is of type âunsigned char *â
slony1_funcs.c: In function âslon_quote_identifierâ:
slony1_funcs.c:1094: error: too few arguments to function
âScanKeywordLookupâ
slony1_funcs.c: In function âgetClusterStatusâ:
slony1_funcs.c:1247: error: too many arguments to function âtypenameTypeIdâ
slony1_funcs.c:1268: error: âTEXTOIDâ undeclared (first use in this
function)
slony1_funcs.c:1321: error: âINT4OIDâ undeclared (first use in this
function)
gmake[2]: *** [slony1_funcs.o] Error 1
gmake[2]: Leaving directory `/root/slony1-2.0.0-rc1/src/backend'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/root/slony1-2.0.0-rc1/src'
gmake: *** [all] Error 2







--
View this message in context: http://postgresql.1045698.n5.nabble.com/Trouble-installing-Slony-2-0-tp5799687.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Re: Trouble installing Slony 2.0

From
Alberto Cabello Sánchez
Date:
On Fri, 11 Apr 2014 09:48:31 -0700 (PDT)
sparikh <sparikh@carcharging.com> wrote:

> I have been struggling to install slony 2.0 for past few days.
[...]
> gmake[1]: Entering directory `/root/slony1-2.0.0-rc1/src'

Maybe a more recent/stable version will solve it. Especially since you are
using an RC.

--
Alberto Cabello Sánchez
<alberto@unex.es>


Re: Trouble installing Slony 2.0

From
Alberto Cabello Sánchez
Date:
On Tue, 15 Apr 2014 22:07:09 +0000
Samir Parikh <SParikh@CarCharging.com> wrote:

> Thanks Alberto.  I could figure out that and install the software successfully.
> Is there any nice document you can suggest for configuring slony (set up
> replication, sets,nodes etc...).

Hi, Samir.

There are many. You should begin with the official docs, esp. chapters 1, 2 and 3:
http://slony.info/documentation/2.0/index.html

When you are familiar with the terminology you can check some recipes elsewhere
to get an outlook of the tasks involved:

http://raghavt.blogspot.com.es/2012/07/simple-slony-i-replication-setup.html
http://www.howtoforge.com/configuring-slony-i-cascading-replication-on-postgresql-8.3

But Slony-I documentation is still the best resource.

--
Alberto Cabello Sánchez
<alberto@unex.es>