2.7. Installing pgpool-regclass

If you are using PostgreSQL 9.4 or later, you can skip this section.

If you are using PostgreSQL 8.0 to PostgreSQL 9.3, installing pgpool_regclass function on all PostgreSQL to be accessed by Pgpool-II is strongly recommended, as it is used internally by Pgpool-II. Without this, handling of duplicate table names in different schema might cause trouble (temporary tables aren't a problem). If you are using PostgreSQL 9.4 or later, installing pgpool_regclass is not necessary since an equivalent (to_regclass) is included in the PostgreSQL core.

$ cd pgpool-II-4.1.22/src/sql/pgpool-regclass
$ make
$ make install
   

After this:

$ psql template1
=# CREATE EXTENSION pgpool_regclass;
   

or

$ psql -f pgpool-regclass.sql template1
   

Executing CREATE EXTENSION or pgpool-regclass.sql should be performed on every databases accessed via Pgpool-II. However, you do not need to do this for a database created after the execution of CREATE EXTENSION or psql -f pgpool-regclass.sql template1, as this template database will be cloned to create new databases.