Version 1.3.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released, making the tool more robust through a new code infrastructure in terms of output, subprocesses, remote commands, file system, events (‘hooks’) and metadata management. Barman now supports: hook scripts before and after archiving a WAL file network compression of remote backup and […]
Announcing repmgr 2.0
/0 Comments/in Christian's PlanetPostgreSQL, PostgreSQL, repmgr /by Christian KruseVersion 2.0 of repmgr, Replication Manager for PostgreSQL clusters, has been released. This release introduces a new experimental feature, autofailover. With autofailover repmgr is able to automatically promote a standby and let the other standbys follow the new master, without interaction of the DBA. It also adds a lot of bug fixes and several new […]
Announcing repmgr 2.0RC2
/0 Comments/in Christian's PlanetPostgreSQL, PostgreSQL, repmgr /by Christian KruseVersion 2.0RC2 of repmgr, Replication Manager for PostgreSQL clusters, has been released. This release introduces a new experimental feature, autofailover. With autofailover repmgr is able to automatically promote a standby and let the other standbys follow the new master, without interaction of the DBA. It also adds a lot of bug fixes and several new […]
Row security in PostgreSQL – Overview
/5 Comments/in Craig's PlanetPostgreSQL /by craig.ringerIn the next week I will be writing a series of posts about the row-security work I’ve been doing for PostgreSQL 9.4 as part of the EU’s AXLE project. I will be outlining the history, approaches tried, current status, remaining issues, and future work required. To open the series, I’d like to talk about what […]
Streaming replication slots in PostgreSQL 9.4
/15 Comments/in Craig's PlanetPostgreSQL /by craig.ringerStreaming replication slots are a pending feature in PostgreSQL 9.4, as part of the logical changeset extraction feature. What are they for, what do you need to know, what changes? What are replication slots? Streaming replication slots are a new facility introduced in PostgreSQL 9.4. They are a persistent record of the state of a […]
Managing PostgreSQL in a devops environment
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniWith every new release, PostgreSQL gets better at addressing the needs of developers, database and system administrators. If you are part of a dynamic business that delivers high quality products or services, Postgres is a candidate technology for managing your databases (in case you have any).
Announcing repmgr 2.0RC1
/0 Comments/in Christian's PlanetPostgreSQL, repmgr /by Christian KruseVersion 2.0RC1 of repmgr, Replication Manager for PostgreSQL clusters, has been released. This release introduces a new experimental feature, autofailover. With autofailover repmgr is able to automatically promote a standby and let the other standbys follow the new master, without interaction of the DBA. It also adds a lot of bug fixes and several new […]
Announcing Barman 1.3.0
/0 Comments/in Barman, International News /by Gabriele BartoliniVersion 1.3.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released, making the tool more robust through a new code infrastructure in terms of output, subprocesses, remote commands, file system, events (‘hooks’) and metadata management. Barman now supports: hook scripts before and after archiving a WAL file network compression of remote backup and […]
Compiling PostgreSQL extensions with Visual Studio on Windows
/50 Comments/in Craig's PlanetPostgreSQL /by craig.ringerI’ve seen a number of users struggling with building PostgreSQL extensions under Visual Studio, so I thought I’d see what’s involved in getting it working. The result is this tutorial, showing how to compile a simple extension with Visual Studio 2010 Express Edition. Requirements You will need a supported version of Visual Studio installed. These […]
Enterprise Support – The final hurdle for PostgreSQL?
/0 Comments/in Howard's PlanetPostgreSQL, United Kingdom News /by Umair ShahidIt’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 […]
PostgreSQL guts: What is “resjunk”?
/0 Comments/in Craig's PlanetPostgreSQL, PostgreSQL /by craig.ringerI’m delving into the PostgreSQL parser, query rewriter and query planner at the moment, as part of work on row-level security for the AXLE project. As I’ve noticed that there’s some great documentation on the overall structure and flow but not much on some of the details I thought I’d start posting about some of […]