Wednesday, January 16

United Kingdom News

Enterprise Support – The final hurdle for PostgreSQL?

Howard's PlanetPostgreSQL, United Kingdom News
It's been an interesting 9 months for me personally, joining the 2ndQuadrant team in April 2013 to lead marketing. I've been particularly impressed by the quality and skills of the people I've met - not just from 2ndQuadrant but also the Postgres Community, from many countries around the world. Of course what has also impressed me is the quality of PostgreSQL. ┬áThe more I learn, the more I can see there is a hugely exciting opportunity ahead for everyone involved. What's puzzled me more than anything though is how little I personally knew about Postgres. With 18 years of commercial marketing in the IT industry, I confess I knew little about Postgres until joining 2ndQuadrant, so I'm frequently making comments like 'wow' as I learn more! I'm always intrigued to find out what (more…)

EuroPython 2011: “The Python and the Elephant”

International News, United Kingdom News
During EuroPython 2011, the major annual event for Python developers and users in Europe, 2ndQuadrant will deliver a special hands-on training session entitled "The Python and the Elephant".This 4-hour workshop will take place on Thursday June 23 and will cover the two main techniques for writing applications in Python for PostgreSQL: standard client applications using PsycoPG or internal extensions using the PL/Python language for stored procedures. (more…)

How not to build PostgreSQL 9.0 extensions on RPM platforms

Greg's PlanetPostgreSQL, PostgreSQL, United Kingdom News, United States News
For a long time, adding packages to RedHat derived Linux systems has been called "RPM Hell", for good reason.  Particularly before the yum utility came about to help, getting RPM to do the right thing has often been a troublesome task.  I was reminded of this again today, while trying to compile a PostgreSQL extension on two nearly identical CentOS systems.PostgreSQL provides an API named PGXS that lets you build server extensions that both leverage the code library of the server and communicate with it.  We use PGXS to install our repmgr utility, and having that well defined API let the program be developed externally from the main server core.  Many popular pieces of PostgreSQL add-ons rely on PGXS to build themselves.  In fact, the contrib modules that come with (more…)

Easier PostgreSQL 9.0 clusters with repmgr

Greg's PlanetPostgreSQL, International News, United Kingdom News, United States News
When PostgreSQL 9.0 shipped a few months ago, it included several new replication features. It's obvious that you can use these features to build clusters of servers for both high availability and read query scaling purposes. What hasn't been so obvious is how to manage that cluster easily. Getting a number of nodes installed and synchronized with their master isn't that difficult. But while the basic functions necessary to monitor multiple nodes and help make decisions like "which node do I promote if the master fails?" were included in 9.0, the way they expose this information is based on internal server units. There are a few common complaints that always seem to show up once you actually consider putting one of these clusters into a production environment: How do I handle (more…)