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.2.3/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.