adapters.js

/**
 * Global adapter config
 * 
 * The `adapters` configuration object lets you create different global "saved settings"
 * that you can mix and match in your models.  The `default` option indicates which 
 * "saved setting" should be used if a model doesn't have an adapter specified.
 *
 * Keep in mind that options you define directly in your model definitions
 * will override these settings.
 *
 * For more information on adapter configuration, check out:
 * http://sailsjs.org/#documentation
 */

module.exports.connections = {

  // If you leave the adapter config unspecified 
  // in a model definition, 'default' will be used.

  // In-memory adapter for DEVELOPMENT ONLY
  memory: {
    module: 'sails-memory'
  },

  // Persistent adapter for DEVELOPMENT ONLY
  // (data IS preserved when the server shuts down)
  disk: {
    module: 'sails-disk'
  },

  // MySQL is the world's most popular relational database.
//   // Learn more: http://en.wikipedia.org/wiki/MySQL
  
 'innit_app_server' : {
    adapter : 'sails-postgresql',
    host: 'localhost',
    user: 'innit_dev',
    database : 'innit_app_server',
    password: '',
    port: 5432,
    pool: false
},

 'mcguffy_mccloud2': {
    adapter : 'sails-postgresql',
    host: 'localhost',
    user: 'robwormald',
    database : 'innit_data',
    password: '',
    port: 5432,
    pool: false
},


  // mysql: {

  //   module: 'sails-mysql',
  //   host: 'YOUR_MYSQL_SERVER_HOSTNAME_OR_IP_ADDRESS',
  //   user: 'YOUR_MYSQL_USER',
  //   // Psst.. You can put your password in config/local.js instead
  //   // so you don't inadvertently push it up if you're using version control
  //   password: 'YOUR_MYSQL_PASSWORD', 
  //   database: 'YOUR_MYSQL_DB'
  // }
};

//below this line is .10 only (i think)

/**
 * Default model definition
 *
 * Unless you override them in each model file, the following options
 * will be included in all of your models by default:
 */
module.exports.model = {
 
  // The default connection(s) to use with your models
  // i.e. your app's primary database
  connections: [ 'mcguffy_mccloud2' ],
    migrate : 'safe'
};