If you're running PostgreSQL on a port other than the default (5432), you can also use the dblink_mapping_jobmon table to change the port that dblink will use. Grant all on all sequences in schema jobmon to rolename Grant execute on all functions in schema jobmon to rolename Grant select, insert, update, delete on all tables in schema jobmon to rolename

Grant usage on schema dblink to rolename The following permissions should be given to the above role (substitute relevant schema names as appropriate): grant usage on schema jobmon to rolename It will be connecting back to the same postgres database locally.

INSERT INTO jobmon.dblink_mapping_jobmon (username, pwd) VALUES ('rolename', 'rolepassword') Įnsure you add the relevant line to the pg_hba.conf file for this role. To allow non-superusers to use dblink, you'll need to enter role credentials into the dblink_mapping_jobmon table that pg_jobmon installs. This extension uses dblink to connect back to the same database that pg_jobmon is running in (this is how the non-transactional magic is done).

(Note: You can change the schema name to be whatever you wish, but it cannot be changed after installation.) CREATE SCHEMA jobmon ĬREATE EXTENSION pg_jobmon SCHEMA jobmon Log into PostgreSQL and run the following commands: In the directory where you downloaded pg_jobmon run make Requirements: PostgreSQL 9.2+, dblink extension The logging is done in a NON-TRANSACTIONAL method, so that if your function/transaction fails for any reason, any information written to that point will be kept in the log tables rather than rolled back.įor more information on how to use pg_jobmon, please see pg_jobmon/doc/pg_jobmon.md INSTALLATION Pg_jobmon is a PostgreSQL extension designed to add autonomous logging capabilities to transactions and functions.

Postgresql 9.2 install dblink