Christopher Browne cbbrowne at ca.afilias.info
Mon Apr 16 15:01:05 PDT 2007
Sergey.Potapov at mobido.ru writes:
> I get error:
> <stdin>:6: Possible unsupported PostgreSQL version 8.2
> <stdin>:6: loading of file /usr/share/pgsql//slony1_funcs.sql: PGRES_FATAL_ERROR ERROR: current transaction is
> aborted, commands ignored until end of transaction block
> ERROR: current transaction is aborted, commands ignored until end of transaction block
> <stdin>:6: ERROR: no admin conninfo for node 134650552
> How to solve this problem?

You might take a peek in the PostgreSQL logs to see what it complained
about when trying to load /usr/share/pgsql//slony1_funcs.sql.

It seems rather curious that it reported your PostgreSQL version as
being an "Possible unsupported" version; there were some repairs in
1.2.8 to the handling of version numbers.  Indeed, based on the above
message, you can't be running 1.2.9, because the form of the error
message should be:

<stdin>:6: Possible unsupported PostgreSQL version (%d) %d.%d, defaulting to 8.1 support

Take a look in slony1_funcs.sql for functions slonyVersionMajor(),
slonyVersionMinor(), and slonyVersionPatchlevel(); I suspect you're
actually looking at some earlier version.

The error message is consistent with something we ran into with about
1.2.6 or 1.2.7 when a function wasn't properly commented on...
-- 
(reverse (concatenate 'string "ofni.sailifa.ac" "@" "enworbbc"))
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)


More information about the Slony1-bugs mailing list