1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
DO $$
BEGIN
IF (SELECT setting::integer/100 FROM pg_settings WHERE name = 'server_version_num') = 904 THEN
CREATE EXTENSION IF NOT EXISTS pglogical_origin;
END IF;
END;$$;
CREATE EXTENSION pglogical;
SELECT pglogical.pglogical_max_proto_version();
pglogical_max_proto_version
-----------------------------
1
(1 row)
SELECT pglogical.pglogical_min_proto_version();
pglogical_min_proto_version
-----------------------------
1
(1 row)
-- test extension version
SELECT pglogical.pglogical_version() = extversion
FROM pg_extension
WHERE extname = 'pglogical';
?column?
----------
t
(1 row)
DROP EXTENSION pglogical;
-- test upgrades
DO $$
BEGIN
IF version() ~ 'Postgres-XL' THEN
CREATE EXTENSION IF NOT EXISTS pglogical;
ELSE
CREATE EXTENSION IF NOT EXISTS pglogical VERSION '1.0.0';
END IF;
END;
$$;
ALTER EXTENSION pglogical UPDATE;
SELECT pglogical.pglogical_version() = extversion
FROM pg_extension
WHERE extname = 'pglogical';
?column?
----------
t
(1 row)
DROP EXTENSION pglogical;
|
