logtopg 0.0.5

Python logging handler that stores logs in postgresql

Install

Grab the code with pip:

$ pip install logtopg

But you also have to install the ltree contrib module into your database:

$ sudo -u postgres psql -c "create extension ltree";

Try it out

Here’s an example script:

import logging
import logging.config

log = logging.getLogger("logtopg.example")

if __name__ == "__main__":

    # These need to be correct, so you'll likely need to change them.
    db_credentials = {
        "database":"logtopg",
        "host":"localhost",
        "user":"logtopg",
        "password":"l0gt0pg"}

    d = dict({
        'disable_existing_loggers': False,

        'handlers': {

            'pg': {
                'class': 'logtopg.PGHandler',
                'level': 'DEBUG',
                'log_table_name': 'logtopg_example',

                'params': db_credentials},

            "console": {
                "class": "logging.StreamHandler",
                "level": "DEBUG"
            }},

        'root': {
            'handlers': ["console", 'pg'],
            'level': 'DEBUG'},

        'version': 1})

    logging.config.dictConfig(d)

    log.debug("debug!")
    log.info("info!")
    log.warn("warn!")
    log.error("error!")
    log.critical("critical!")

Contribute to logtopg

Get a copy of the code:

$ git clone --origin github https://github.com/216software/logtopg.git

Install it like this:

$ cd logtopg
$ pip install -e .

Create test user and test database:

$ sudo -u postgres createuser --pwprompt logtopg
$ sudo -u postgres createdb --owner logtopg logtopg
$ sudo -u postgres psql -c "create extension ltree";

Then run the tests like this:

$ python tests/test_logtopg.py
.....
----------------------------------------------------------------------
Ran 5 tests in 0.465s

OK

And hopefully stuff works!