Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
SM Postgresql Extension Set (postgresql, pgpool, pgbouncer, slony, extensions)
Shell Makefile HTML
tree: 396a341ed7

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
pg_top
pgbouncer
pgpool
pgtune
postgis
postgresql
queue_classic
repmgr
rubyrep
slony
README.md
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.