Postgres-XC, read/write-scalable multi-master symmetric cluster based on PostgreSQL, version 1.0.1 has been released today.

This minor release is based on the latest PostgreSQL 9.1.5+alpha, meaning that all the patches in PostgreSQL 9.1 stable branch have been merged up to commit d10ddf4 (3rd of September 2012).

You can download the source tarball directly from here.
Like PostgreSQL, this tarball contains all the HTML and man documentation.

The documentation of 1.0, including release notes, is available here.

Around 20 bugs have been fixed since 1.0.0, with in particular those fixes:

  • Applications like pgadmin had problems to connect to Postgres-XC server.
  • Drop of sequence was not managed correctly when its database was dropped

You can find all the details in the release notes here.

The project can be followed on Source Forge:
And a couple of GIT repositories are used for development:

  • SourceForge
  • Github
  • Twitter: @PostgresXCBot, bot giving tweets about the commits in Postgres-XC GIT repository

The project members are currently working hard on the next version of Postgres-XC that will include those features:

  • triggers (being implemented)
  • Merge with PostgreSQL 9.2 code (already committed)
  • RETURNING, WHERE CURRENT OF (being implemented)
  • Insure consistency of utilities that cannot run inside transaction block (ex: CREATE DATABASE safely insured in multiple nodes, being implemented)
  • Change table distribution type with ALTER TABLE (already committed)
  • Support for cursors (already committed)
  • Stuff related to node addition and deletion
  • and other things…

The project is under the same license as PostgreSQL, and is managed under a single entity called “Postgres-XC Development Group”.

Have fun with this stable release.

This year, Postgres-XC has a tutorial at PGCon. Yeah.
Based on the schedule of PGCon 2012, XC team has 3 hours to make you masters of this cluster based on PostgreSQL.

We are working hard at shaping up the presentation flow following those guidelines.

  1. Postgres-XC, what it is and what it is not
  2. Postgres-XC elements — Global Transaction Manager, Coordinator and Datanode
  3. How to design a Postgres-XC cluster — cluster configuration and table design
  4. Build and installation
  5. How to configure Postgres-XC
  6. How to test Postgres-XC
  7. Cluster-wide backup and restore
  8. High availability and component failure
  9. Postgres-XC as a community, be a developer!

Well, to be honest, 3 hours is short for a tutorial that would need a full course of 2 days. So we are planning to have some demos running during the presentation, but for sure we will not be able to show as much as we wish during this short time.
So, you, who is reading this post and will of course participate in Postgres-XC tutorial at PGCon, what do you expect from this tutorial? Are there things you would like to see more than others based on the guidelines written above?

Feel free to post your opinions here, we’ll try to take into account everybody’s viewpoint!

©2010-2013 Michael Paquier All content is ©Copyright of Otacoo.com 2010-2013. Privacy Policy - Terms of Use