Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

SM Postgresql Extension Set (postgresql, pgpool, pgbouncer, slony, extensions)

tree: 2fe2924de4

Fetching latest commit…

Octocat-spinner-32-eaf2f5

Cannot retrieve the latest commit at this time

Octocat-spinner-32 pg_top
Octocat-spinner-32 pgbouncer
Octocat-spinner-32 pgpool
Octocat-spinner-32 pgtune
Octocat-spinner-32 postgis
Octocat-spinner-32 postgresql
Octocat-spinner-32 queue_classic
Octocat-spinner-32 repmgr
Octocat-spinner-32 rubyrep
Octocat-spinner-32 slony
Octocat-spinner-32 README.md
Octocat-spinner-32 replication
README.md

SM Framework Postgresql Extension Set

This SM Framework extension set contains the following postgresql related extensions:

postgresql

The PostgreSQL database system. Read postgresql/README.md for more details.

pgpool

Provides Connection Pooling, Replication, Load Balancing, Limiting Exceeding Connections, Parallel Query. Read pgpool/README.md for more details.

pgbouncer

Provides Session pooling, Transaction pooling, Statement pooling. Read pgbouncer/README.md for more details.

postgis

adds support for geographic "spatial" objects to the PostgreSQL object-relational database. Read postgis/README.md for more details.

queue_classic

a PostgreSQL-backed queueing library that is focused on concurrent job locking, minimizing database load & providing a simple & intuitive user experience. Read queue_classic/README.md for more details.

repmgr

a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases. Read repmgr/README.md for more details.

slony

a "master to multiple slaves" trigger based replication system for PostgreSQL supporting cascading (e.g. - a node can feed another node which feeds another node...) and failover. Read slony/README.md for more details.

Installation

To install this extension set, with the latest SM Framework you can do:

sm get head               # Ensuring we are on the latest SM Framework.
sm set install postgresql # Installing this (known) extension set.

Alternatively the uri may be specified:

sm set install postgresql git://github.com/sm/sm-postgresql.git

After this you may issue the extension specific commands you require such as:

sm postgresql install
sm pgpool install

NOTE: postgresql used to be located in sm-databases, so if you have an older sm-databases upgrade it so that you no longer have a postgresql extension in it:

sm set install databases
Something went wrong with that request. Please try again.