Extended features

pgAdmin III's functionality can be further enhanced using the admin contrib module for PostgreSQL. This is a library of additional functions that may be installed on your server which allows pgAdmin to offer additional features, such as:

The admin module is installed and activated by default if you are running the 'official' pgInstaller distribution of PostgreSQL for Windows, however, if you are running any other version of PostgreSQL you will need to manually install the module. To do so, simply copy the /xtra/admin directory from the pgAdmin source distribution to the /contrib directory of your pre-configured PostgreSQL source tree. Run the following commands:

    # cd $PGSRC/contrib/admin
    # make all
    # make install

The module should now be built, and installed into your existing PostgreSQL installation. to be used, you must now install the module into the database you use as pgAdmin's Initial DB (normally template1, though you may wish to use a different database). To do so, locate the admin.sql file installed in the previous step - normally this may be found in /usr/local/pgsql/share/contrib/ and run it against your database. You will normally need to do this as the PostgreSQL superuser:

    $ psql template1 < /usr/local/pgsql/share/contrib/admin.sql

The next time you connect to the server with pgAdmin, it will detect the presence of the admin module and offer full functionality.