Connect PG Simple
A simple, minimal PostgreSQL session store for Express/Connect
npm install connect-pg-simple
Once npm installed the module, you need to create the session table in your database. For that you can use the table.sql file provided with the module:
psql mydatabase < node_modules/connect-pg-simple/table.sql
Or simply play the file via a GUI, like the pgAdminIII queries tool.
connect-pg-simple requires PostgreSQL version 9.5 or above.
Examples are based on Express 4.
var session = ;app;
Advanced example showing some custom options:
var pg =session =pgSession = session;var pgPool =// Insert pool options here;app;
Express 3 (and similar for Connect):
var express = ;app;
- pool - Recommended. Connection pool object (compatible with pg.Pool) for the underlying database module. The conString option is ignored if this option is specified.
- pgPromise - Existing instance of
pg-promiseto be used for DB communications. The conString option is ignored if this option is specified.
- conString - If you don't specify a pool object, use this option or
conObjectto specify a PostgreSQL connection string and this module will create a new pool for you. If the connection string is in the
DATABASE_URLenvironment variable (as you do by default on eg. Heroku) – then this module fallback to that if this option is not specified.
- conObject - If you don't specify a pool object, use this option or
conStringto specify a PostgreSQL Pool connection object and this module will create a new pool for you.
- ttl - the time to live for the session in the database – specified in seconds. Defaults to the cookie maxAge if the cookie has a maxAge defined and otherwise defaults to one day.
- schemaName - if your session table is in another Postgres schema than the default (it normally isn't), then you can specify that here.
- tableName - if your session table is named something else than
session, then you can specify that here.
- pruneSessionInterval - sets the delay in seconds at which expired sessions are pruned from the database. Default is
60seconds. If set to
falseno automatic pruning will happen. By default every delay is randomized between 50% and 150% of set value, resulting in an average delay equal to the set value, but spread out to even the load on the database. Automatic pruning will happen
pruneSessionIntervalseconds after the last pruning (includes manual prunes).
- pruneSessionRandomizedInterval – if set to
false, then the exact value of
pruneSessionIntervalwill be used in all delays. No randomization will happen. If multiple instances all start at once, disabling randomization can mean that multiple instances are all triggering pruning at once, causing unnecessary load on the database. Can also be set to a method, taking a numeric
delayparameter and returning a modified one, thus allowing a custom delay algorithm if wanted.
- errorLog – the method used to log errors in those cases where an error can't be returned to a callback. Defaults to
console.error(), but can be useful to override if one eg. uses Bunyan for logging.
- close() – if this module used its own database module to connect to Postgres, then this will shut that connection down to allow a graceful shutdown.
- pruneSessions([callback(err)]) – will prune old sessions. Only really needed to be called if pruneSessionInterval has been set to
false– which can be useful if one wants improved control of the pruning.
Available as part of the Tidelift Subscription.
The maintainers of connect-pg-simple and thousands of other packages are working with Tidelift to deliver commercial support and maintenance for the open source packages you use to build your applications. Save time, reduce risk, and improve code health, while paying the maintainers of the exact packages you use. Learn more.