winston-postgre

A winston transporter for PostgreSQL database

Installation

npm install winston-postgre

Also, you need to have a table on your postgre database with the following structure:

CREATE TABLE nodelogs
(
  logdate time without time zone,
  level text,
  message text
);

Options

• connectionString: The PostgreSQL connection string.
• schema: The schema which the table was created.
• table: The table name inside the database under the schema.
• level: The winston log level

See the default values used as example:

var options = {
  "connectionString" : "postgres://username:password@localhost/database",
  "schema" : "public",
  "table" : "nodelogs",
  "level" : "silly"
};

Usage

var winston = require('winston');
var db = require('../lib/winston-postgre');
 
var options = {
  "connectionString" : "postgres://postgres:postgres@localhost/winstontest",
  "schema" : "public",
  "table" : "nodelogs",
  "level" : "silly"
};
 
winston.add(winston.transports.PostgreSQL, options);
 
winston.log('error', 'Just a simple error log');
winston.log('info', 'Just a simple info log');
winston.log('warn', 'Just a simple warn log');
winston.log('debug', 'Just a simple debug log');
winston.log('verbose', 'Just a simple verbose log');

Feel free to open an issue or do a pull request.