pgpool-II 4.3.7 Documentation
Prev | Up | Chapter 2. Installation of Pgpool-II | Next

# 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.3.7/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.

Prev | Home | Next
Installing pgpool_recovery | Up | Creating insert_lock table