Tim Goodaire wrote:
On 9/29/06, Steven Mocking <[EMAIL PROTECTED]> wrote:
A crucial difference might be that the first server ran postgresql 8.1
and the second 7.3 (7.3.2 to be exact). Also, the second was compiled
from source.

What am I doing wrong?


The problem is that postgresql 7.3.2 isn't supported by slony-I, because
it's lacking namespace support. The minimum requirement is postgresql 7.3.3.
And we just happen to have 7.3.2 installed on nearly all our production servers.

On a more positive note, might the attached patch be a good addition to the slony-I configure script for future stable releases? The current code doesn't check the micro-version and a check like that would prevent others from wasting as much time as I did.

Steven.
6085c6085
<     PG_VERSION=`$PG_CONFIG_LOCATION --version|cut -f2- -d' '|cut -f1 -d'd'|cut -f-2 -d'.'`
---
>     PG_VERSION=`$PG_CONFIG_LOCATION --version|cut -f2- -d' '|cut -f1 -d'd'|cut -f-3 -d'.'`
6090c6090
<            sed 's/\([0-9]*\).\([0-9]*\)/\1/'`
---
>            sed 's/\([0-9]*\).\([0-9]*\).\([0-9]*\)/\1/'`
6092c6092,6094
<            sed 's/\([0-9]*\).\([0-9]*\)/\2/'`
---
>            sed 's/\([0-9]*\).\([0-9]*\).\([0-9]*\)/\2/'`
>     PG_MICRO_VERSION=`echo $PG_VERSION |\
>            sed 's/\([0-9]*\).\([0-9]*\).\([0-9]*\)/\3/'`
6094,6095c6096,6097
< 	if test $PG_MINOR_VERSION -gt 2; then
< 	    echo "$as_me:$LINENO: result: $PG_VERSION" >&5
---
> 	if test $PG_MINOR_VERSION -gt 2 -a $PG_MICRO_VERSION -gt 2; then
>       echo "$as_me:$LINENO: result: $PG_VERSION" >&5
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to