PG 11 Fix

[Yo71MUd2gEu5]

Seems that PG 11 is not supported fully.

PostgreSQL server info:
Version : 11.3
Release : 1PGDG.rhel7
From repo : pgdg11

Slony info:
Version : 2.2.7
Release : 2.rhel7
From repo : pgdg11

When trying to initialize master i've got a message:

slonik <<EOF

CLUSTER NAME = CLUSTER;
NODE 1 ADMIN CONNINFO = 'dbname=SL_MASTER user=slonik';
INIT CLUSTER ( ID = 1, COMMENT = 'Asterisk DB replication cluster' );

EOF

initialzing cluster
:4: Possible unsupported PostgreSQL version (110300) 11.3, defaulting to 8.4 support

[ssinger]

It actually does work against PG 11, the warning can be ignored. The last version of slony was released while PG 11 was still beta(I think)
In the next release I will remove the warning for PG11.

[tim-rex]

It appears this is still the case for all postgres versions above PG13

I only mention this since slony 2.2.11 just landed, and the release notes indicate support for PG15

slonik.c

else	/* above 13 */
	{
		use_major = 8;
		use_minor = 4;
		printf("%s:%d: Possible unsupported PostgreSQL "
			   "version (%d) %d.%d, defaulting to support for latest\n",
			   stmt->stmt_filename, stmt->stmt_lno, adminfo->pg_version,
		(adminfo->pg_version / 10000), ((adminfo->pg_version % 10000) / 100));
	}

[ssinger]

This should be fixed in 2.2.11
https://github.com/ssinger/slony1-engine/blob/REL_2_2_STABLE/src/slonik/slonik.c

(though I was a bit late in pushing 2.2.11 to this github repo (The official repo is at git.postgresql.org)

[tim-rex]

Ahh, so I see. Thanks.

It looks like load_slony_base() is setup correctly, though load_slony_functions() still considers PG15 as "possibly unsupported"

[ssinger]

I've pushed a fix for this to REL_2_2_STABLE.
I'm hesitant to cut a 2.2.12 release just to remove the warning(but could be convinced otherwise)