pg_jobmon - PostgreSQL Extension for logging and monitoring automated jobs

  •        51

Log into PostgreSQL and run the following commands. Schema can be whatever you wish, but it cannot be changed after installation. This extension uses dblink to connect back to the same database that pg_jobmon is running on (this is how the non-transactional magic is done). To allow non-superusers to use dblink, you'll need to enter role credentials into the dblink_mapping_jobmon table that pg_jobmon installs.

http://www.omniti.com
https://github.com/omniti-labs/pg_jobmon

Tags
Implementation
License
Platform

   




Related Projects

PostgreSQL - Powerful, Open Source Object-Relational Database System

  •    C

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It has native programming interfaces for most of the programming language.

pg - PostgreSQL ORM for Golang with focus on PostgreSQL features and performance

  •    Go

PostgreSQL ORM for Golang with focus on PostgreSQL features and performance. It supports Basic types, Multidimensional Arrays, Transactions, Prepared statements, Queries retries on network errors, Automatic connection pooling with circuit breaker support, Bulk/batch inserts and updates, Pagination and URL filters helpers, Migrations, Sharding and lot more.

pgMail - PostgreSQL Email Stored Funct.

  •    Perl

pgMail is a small TCL based script that you can store within any PostgreSQL database. Once it is stored there, you can create any number of specialized procedures to send email from directly within PostgreSQL like emailing a customer when product ships. FYI! This project has moved to GITHUB! You can see the repository here: https://github.com/captbrando/pgMail WE HAVE MOVED!!! Please visit the project page (linked below) for all new and relevant information, including requests for help!

Scheme-PG

  •    

Scheme-PG is a MzScheme extension and set of associated Scheme procedures and macros that combine to provide a simple yet powerful interface between PLT Scheme and the PostgreSQL database management system.


pg-boss - Queueing jobs in Node.js using PostgreSQL like a boss

  •    Javascript

pg-boss is a job queue built in Node.js on top of PostgreSQL in order to provide background processing and reliable asynchronous execution to Node.js applications. pg-boss relies on SKIP LOCKED, a feature introduced in PostgreSQL 9.5 written specifically for message queues, in order to resolve record locking challenges inherent with relational databases. This brings the safety of guaranteed atomic commits of a relational database to your asynchronous job processing.

agensgraph - AgensGraph, a transactional graph database based on PostgreSQL

  •    C

AgensGraph is a new generation multi-model graph database for the modern complex data environment. AgensGraph is a multi-model database, which supports the relational and graph data model at the same time that enables developers to integrate the legacy relational data model and the flexible graph data model in one database. AgensGraph supports ANSI-SQL and openCypher (http://www.opencypher.org). SQL queries and Cypher queries can be integrated into a single query in AgensGraph. AgensGraph is based on the powerful PostgreSQL RDBMS, and is very robust, fully-featured and ready for enterprise use. AgensGraph is optimized for handling complex connected graph data and provides plenty of powerful database features essential to the enterprise database environment including ACID transactions, multi-version concurrency control, stored procedure, triggers, constraints, sophisticated monitoring and a flexible data model (JSON). Moreover, AgensGraph leverages the rich eco-systems of PostgreSQL and can be extended with many outstanding external modules, like PostGIS.

PGObserver - A battle-tested, flexible & comprehensive monitoring solution for your PostgreSQL databases

  •    Python

PGObserver is a battle-tested monitoring solution for your PostgreSQL databases. It covers almost all the metrics provided by the database engine's internal statistics collector, and works out of the box with all PostgreSQL versions (beginning with 9.0) as well as AWS RDS. You don’t have to install any non-standard, server-side database extensions to take advantage of its core functionality, nor do you need to register any privileged users.For some metrics you must install data-gathering wrapper functions — also known as stored procedures — on the server being monitored. This will enable you to circumvent the superuser requirements.

upsert - Upsert on MySQL, PostgreSQL, and SQLite3

  •    Ruby

Make it easy to upsert on traditional RDBMS like MySQL, PostgreSQL, and SQLite3—hey look NoSQL!. Transparently creates (and re-uses) stored procedures/functions when necessary. You pass it a bare-metal connection to the database like Mysql2::Client (from mysql2 gem on MRI) or Java::OrgPostgresqlJdbc4::Jdbc4Connection (from jdbc-postgres on Jruby).

Job Scheduler for PostgreSQL

  •    C++

pgjobs is a mechanism for scheduling and executing stored procedures under PostgreSQL database server.

Stored Procedure Generator (for SQL Server 2000/2005)

  •    CSharp

This utility automatically creates all basic stored procedures (SelectAll, SelectRow, InsertRow, UpdateRow, DeleteRow) necessary to access the SQL Server Tables. It also has options to create Data Access Layers for those stored procedures.

Java Stored Procedure system

  •    

The software runs java stored procedures in open source database servers. PostgreSQL is supported, SAP DB support is comming.

meteor-pg - Reactive PostgreSQL for Meteor

  •    Javascript

Provides Meteor integration of the pg-live-select NPM module, bringing reactive SELECT statement result sets from PostgreSQL >= 9.3. If you do not have PostgreSQL server already installed, you may use the numtel:pg-server Meteor Package to bundle the PostgreSQL server directly to your Meteor application.

daboost

  •    

A Visual Studio add-in designed to auto-generate boilerplate data access code. Ever work with a lot of stored procedures? Ever work with displaying data returned by those stored procedures to a stock web forms pages. If so, please take a look at DaBoost. It will save you alot ...

slick-pg - Slick extensions for PostgreSQL

  •    Scala

Slick extensions for PostgreSQL, to support a series of pg data types and related operators/functions. ** Tested on PostgreSQL 10 with Slick 3.2.3. ** Java 8 is required.

Coolstorage - ORM library for .NET

  •    CSharp

The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

Data Tier Generator

  •    CSharp

Microsoft .NET project that generates SQL Server 2000 scripts for stored procedures and C# classes used to access those stored procedures. The stored proecedures generated are as follows: Insert, Update, Delete, Select, SelectByPK, SelectByFK

DataLG

  •    ASPNET

DataLG is a Data Access Layer (DAL) generator. Create stored procedures, views, and tables on the database side, then use DataLG to create an assembly (and its source) to interact with them. Works with: Ms Sql Server, Sqlite 3, Mysql 4-5, and PostgreSQL.

JavaDB

  •    Java

Java DB is Sun's supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based — SQL, JDBC API, and Java EE — yet small, only 2.5 MB.