pgpool2.git / summary / log / commit / refs

commit    de1c8f2eba015b5a4f7aa8c3dcfc14b3965a60f1
Author:   Tatsuo Ishii <ishii@postgresql.org>
Date:     Sun Mar 24 01:17:48 2013 +0000

    Support installation method using CREATE EXTENSION for pgpool-recovery
    and pgpool-regclass.
    
    Older installtion method is still preserved.
    Note: extension names are "pgpool_recovery" and "pgpool_regclass", not
    "pgpool-recovery" and "pgpool-regclass" because latters are not
    convenient in using CREATE EXTENSION command (requires double quotes).


 sql/pgpool-recovery/Makefile                 |  3 +++
 sql/pgpool-recovery/pgpool_recovery--1.0.sql | 19 +++++++++++++++++++
 sql/pgpool-recovery/pgpool_recovery.control  |  5 +++++
 sql/pgpool-regclass/Makefile                 |  3 +++
 sql/pgpool-regclass/pgpool_regclass--1.0.sql |  7 +++++++
 sql/pgpool-regclass/pgpool_regclass.control  |  5 +++++
 6 files changed, 42 insertions(+)

diff --git a/sql/pgpool-recovery/Makefile b/sql/pgpool-recovery/Makefile
index b63db0995..48c9e529b 100644
--- a/sql/pgpool-recovery/Makefile
+++ b/sql/pgpool-recovery/Makefile
@@ -2,6 +2,9 @@ MODULES = pgpool-recovery
 DATA_built = pgpool-recovery.sql
 DATA = uninstall_pgpool-recovery.sql
 
+EXTENSION = pgpool_recovery
+DATA = pgpool_recovery--1.0.sql
+
 # if you are using PostgreSQL 8.0 or later,
 # using pg_config is recommended.
 # if you are not, comment out following line and...
diff --git a/sql/pgpool-recovery/pgpool_recovery--1.0.sql b/sql/pgpool-recovery/pgpool_recovery--1.0.sql
new file mode 100644
index 000000000..884bb05d4
--- /dev/null
+++ b/sql/pgpool-recovery/pgpool_recovery--1.0.sql
@@ -0,0 +1,19 @@
+-- complain if script is sourced in psql, rather than via CREATE EXTENSION
+\echo Use "CREATE EXTENSION pgpool_recovery" to load this file. \quit
+
+CREATE FUNCTION pgpool_recovery(IN script_name text,
+	   IN remote_host text,
+	   IN remote_data_directory text)
+RETURNS bool
+AS 'MODULE_PATHNAME', 'pgpool_recovery'
+LANGUAGE C STRICT;
+
+CREATE FUNCTION pgpool_remote_start(IN remote_host text, IN remote_data_directory text)
+RETURNS bool
+AS 'MODULE_PATHNAME', 'pgpool_remote_start'
+LANGUAGE C STRICT;
+
+CREATE OR REPLACE FUNCTION pgpool_switch_xlog(IN arcive_dir text)
+RETURNS text
+AS 'MODULE_PATHNAME', 'pgpool_switch_xlog'
+LANGUAGE C STRICT;
diff --git a/sql/pgpool-recovery/pgpool_recovery.control b/sql/pgpool-recovery/pgpool_recovery.control
new file mode 100644
index 000000000..ccecdac74
--- /dev/null
+++ b/sql/pgpool-recovery/pgpool_recovery.control
@@ -0,0 +1,5 @@
+# pgpool-recovery extension
+comment = 'recovery functions for pgpool-II'
+default_version = '1.0'
+module_pathname = '$libdir/pgpool-recovery'
+relocatable = true
diff --git a/sql/pgpool-regclass/Makefile b/sql/pgpool-regclass/Makefile
index eebab4b7d..e1188f093 100644
--- a/sql/pgpool-regclass/Makefile
+++ b/sql/pgpool-regclass/Makefile
@@ -2,6 +2,9 @@ MODULES = pgpool-regclass
 DATA_built = pgpool-regclass.sql
 DATA = uninstall_pgpool-regclass.sql
 
+EXTENSION = pgpool_regclass
+DATA = pgpool_regclass--1.0.sql
+
 # if you are using PostgreSQL 8.0 or later,
 # using pg_config is recommended.
 # if you are not, comment out following line and...
diff --git a/sql/pgpool-regclass/pgpool_regclass--1.0.sql b/sql/pgpool-regclass/pgpool_regclass--1.0.sql
new file mode 100644
index 000000000..df773dc92
--- /dev/null
+++ b/sql/pgpool-regclass/pgpool_regclass--1.0.sql
@@ -0,0 +1,7 @@
+-- complain if script is sourced in psql, rather than via CREATE EXTENSION
+\echo Use "CREATE EXTENSION pgpool_regclass" to load this file. \quit
+
+CREATE FUNCTION pgpool_regclass(IN expression cstring)
+RETURNS oid
+AS 'MODULE_PATHNAME', 'pgpool_regclass'
+LANGUAGE C STRICT;
diff --git a/sql/pgpool-regclass/pgpool_regclass.control b/sql/pgpool-regclass/pgpool_regclass.control
new file mode 100644
index 000000000..763ee8901
--- /dev/null
+++ b/sql/pgpool-regclass/pgpool_regclass.control
@@ -0,0 +1,5 @@
+# pgpool-regclass extension
+comment = 'replacement for regclass'
+default_version = '1.0'
+module_pathname = '$libdir/pgpool-regclass'
+relocatable = true


[parent: 44f4faf273de]