Skip to content

pools

Jump to bottom Edit New page
chilts edited this page Feb 23, 2013 · 2 revisions

node-postgres can maintain client pools internally. They are generally accessed via pg#wiki-method-connect but can be directly accessed & manipulated via pg.pools.

hash/object pg.pools.all

A hash of all existing client pools. A pool's key is built by calling JSON.stringify on the first parameter passed to pg.connect unless the first parameter is a callback, in which case JSON.stringify({}) is used.

####example

var pg = require('pg');
console.log(Object.keys(pg.pools.all)); //[]

//connect using defaults or environment variables
//will create a pool by the name of "{}"
pg.connect(function(err, client, done) {
  done();
  console.log(Object.keys(pg.pools.all)); //["{}"]
});

pg.pools.getOrCreate(object key)

Gets a pool by the given key or creates it if it does not yet exist. In either case it returns a modified instance of https://github.com/coopernurse/node-pool pre-configured to return Client instances.

example

var pg = require('pg');

pg.connect(function(err, client, done) {
  var pool = pg.pools.getOrCreate();
  console.log(pool.getPoolSize()); //1
  console.log(pool.availableObjectsCount()); //0
  done();
  console.log(pool.getPoolSize()); //1
  console.log(pool.availableObjectsCount()); //1
});
Add a custom footer
Add a custom sidebar

Clone this wiki locally