{"id":42707,"library":"errsole-postgres","title":"errsole-postgres","description":"PostgreSQL storage plugin for Errsole, a Node.js logger with a built-in web dashboard. Current version is 3.0.0, released as stable. It allows storing application logs in PostgreSQL, integrating with the Errsole ecosystem. Key differentiator: direct log storage in PostgreSQL, leveraging existing database infrastructure. The package ships TypeScript types and uses CommonJS/ESM. Release cadence is not specified, but follows Errsole main package. Note: This is a plugin; requires the main 'errsole' package to function.","status":"active","version":"3.0.0","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","errsole","pg","postgres","postgresql","log","logs","logging","logger","typescript"],"install":[{"cmd":"npm install errsole-postgres","lang":"bash","label":"npm"},{"cmd":"yarn add errsole-postgres","lang":"bash","label":"yarn"},{"cmd":"pnpm add errsole-postgres","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Core logger library; errsole-postgres is a storage plugin for Errsole","package":"errsole","optional":false}],"imports":[{"note":"ESM named export. CommonJS: const { ErrsolePostgres } = require('errsole-postgres')","wrong":"const ErrsolePostgres = require('errsole-postgres').ErrsolePostgres","symbol":"ErrsolePostgres","correct":"import { ErrsolePostgres } from 'errsole-postgres'"},{"note":"Default export available in ESM. CommonJS: const ErrsolePostgres = require('errsole-postgres').default","wrong":"const ErrsolePostgres = require('errsole-postgres')","symbol":"ErrsolePostgres (default)","correct":"import ErrsolePostgres from 'errsole-postgres'"},{"note":"TypeScript only, no runtime value","symbol":"type ErrsolePostgresConfig","correct":"import type { ErrsolePostgresConfig } from 'errsole-postgres'"}],"quickstart":{"code":"import { Errsole } from 'errsole';\nimport { ErrsolePostgres } from 'errsole-postgres';\n\nconst errsole = new Errsole({\n  storage: new ErrsolePostgres({\n    host: process.env.PGHOST ?? 'localhost',\n    port: parseInt(process.env.PGPORT ?? '5432', 10),\n    database: process.env.PGDATABASE ?? 'mydb',\n    user: process.env.PGUSER ?? 'user',\n    password: process.env.PGPASSWORD ?? 'password',\n  }),\n});\n\nerrsole.info('Application started');","lang":"typescript","description":"Initializes Errsole with PostgreSQL storage plugin and logs a message."},"warnings":[{"fix":"Verify PostgreSQL connection with environment variables; test using a simple SELECT 1.","message":"errsole-postgres requires a running PostgreSQL instance. Ensure connection parameters are correct before logging.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Wrap initialization in try-catch or ensure database is accessible.","message":"The ErrsolePostgres constructor throws if connection fails; no fallback to alternative storage.","severity":"gotcha","affected_versions":">=3.0.0"},{"fix":"Use named import '{ ErrsolePostgres }' instead of default import.","message":"In v3, the default export is deprecated in favor of named export; default export remains for backward compatibility.","severity":"deprecated","affected_versions":">=3.0.0"},{"fix":"Update import to 'errsole-postgres' directly.","message":"v3 changed the import path: previously required 'errsole-postgres/dist/index'.","severity":"breaking","affected_versions":"<3.0.0"}],"env_vars":null,"search_vec":"'3.0.0':22 'allow':27 'applic':29 'built':15 'built-in':14 'cadenc':58 'commonjs/esm':56 'current':19 'dashboard':18 'databas':47 'differenti':39 'direct':40 'ecosystem':37 'errsol':2,8,36,64,75,80 'errsole-postgr':1 'exist':46 'follow':63 'function':78 'infrastructur':48 'integr':33 'javascript':79 'key':38 'leverag':45 'log':30,41,84,85,86 'logger':11,87 'main':65,74 'node.js':10 'note':67 'packag':50,66,76 'pg':81 'plugin':6,71 'postgr':3,82 'postgresql':4,32,44,83 'releas':23,57 'requir':72 'ship':51 'specifi':61 'stabl':25 'storag':5,42 'store':28 'type':53 'typescript':52,88 'use':55 'version':20 'web':17","created_at":"2026-06-05T16:56:16.498208+00:00","updated_at":"2026-06-05T16:56:16.498208+00:00","problems":[{"fix":"npm install errsole-postgres@latest","cause":"Module not installed or wrong version","error":"Error: Cannot find module 'errsole-postgres'"},{"fix":"Use named import: const { ErrsolePostgres } = require('errsole-postgres'); or import { ErrsolePostgres } from 'errsole-postgres';","cause":"Using default import incorrectly in CommonJS or ESM","error":"TypeError: ErrsolePostgres is not a constructor"},{"fix":"Start PostgreSQL or update connection config","cause":"PostgreSQL not running or host/port incorrect","error":"ECONNREFUSED :5432 - connection refused"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"errsole-postgres","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database","devops"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}