sails-pg-session

library1.0.1jsnpmunverified

PostgreSQL session store adapter for Sails.js (v1, stable). Stores Express/Sails session data in a PostgreSQL database. Requires manual SQL function installation and config/session.js setup. Compatible with Sails >=10.0.x. Active development but limited to session storage use case.

database

npm install sails-pg-session

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · SAILS-PG-SESSION

sails-pg-session

databasejavascriptv1.0.1

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

sails-pg-session

✓ adapter: 'sails-pg-session' in config/session.js

✗ const session = require('sails-pg-session')

Not a direct require; used as Sails adapter via config. Ensure sails-pg-session is in package.json dependencies.

Shows installation, SQL support function setup, and Sails session config with env variable fallbacks.

// Install: npm install sails-pg-session // Run SQL: psql mydb < ./node_modules/sails-pg-session/sql/sails-pg-session-support.sql // config/session.js: module.exports.session = { adapter: 'sails-pg-session', database: process.env.DB_NAME || 'mydb', host: process.env.DB_HOST || 'localhost', user: process.env.DB_USER || 'myuser', password: process.env.DB_PASSWORD || '', port: process.env.DB_PORT || 5432 };

Debug

Known issues

gotchaMust run sails-pg-session-support.sql before use; table creation required.

fix

Run psql database < node_modules/sails-pg-session/sql/sails-pg-session-support.sql

affects: *

gotchaDatabase connection credentials must be defined in config/session.js; no default fallback may cause errors.

fix

Ensure all fields (database, host, user, password, port) are provided.

affects: *

breakingSupport for Sails versions below 10.0.x unknown; may not work.

fix

Upgrade Sails to 10.0 or higher.

affects: <10.0

Errors

Common errors & fixes

Error: connect ECONNREFUSED

PostgreSQL not running or wrong host/port.

fix

Ensure PostgreSQL is running and config matches (host, port).

error: relation "session" does not exist

Support SQL not yet executed.

fix

Run sails-pg-session-support.sql against your database.

Upgrade

Version history

1.0.1latest on npm

Audit

Dependencies

No dependency data recorded yet.

Agent activity

17 hits · last 30 days

node