Barman 2.1 Version 2.1 of Barman, backup and recovery manager for PostgreSQL, was released Thursday, Jan. 5. The new release, along with several bugfixes, introduces preliminary support for the upcoming PostgreSQL 10, and adds the –archive option to the switch-xlog command. switch-xlog –archive The new –archive option is especially useful when setting up a new […]
Barman 2.1 and the new –archive option
/0 Comments/in Giulio's PlanetPostgreSQL /by Giulio CalacociBarman 2.1 Version 2.1 of Barman, backup and recovery manager for PostgreSQL, was released Thursday, Jan. 5. The new release, along with several bugfixes, introduces preliminary support for the upcoming PostgreSQL 10, and adds the –archive option to the switch-xlog command. switch-xlog –archive The new –archive option is especially useful when setting up a new […]
Managed Database Services – pros and cons
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanUsing a managed service is a very attractive proposition. You are offloading a heck of a lot of worry, especially when it comes to something as complicated and, let’s face it, specialized as a database. Someone else will set it up for you, and back it up, and keep it running, without you having to […]
PostgreSQL’s Popularity Goes Up Again
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsMirror mirror on the wall, Who is the fairest Database of all? A frequently asked question, certainly. DB-Engines recently announced it’s DBMS of the Year. Maybe the cool thing is that PostgreSQL is in 3rd Place. Yee-ha, an open source project is up there! Let’s look closely about what this means. PostgreSQL.org’s agreed response was […]
PGDay.IT 2016 in Prato, Italy
/0 Comments/in 2ndQuadrant, Jonathan's PlanetPostgreSQL /by Jonathan BattiatoThis year, the ITPUG (Italian Postgres User Group) organized PGDay in Prato, my hometown and city where the association was born, although most of the members are from outside of the Tuscany region. It was my pleasure to contribute to the community by sharing my professional experience. I gave a talk about PostgreSQL on Network File System, […]
CHAR16 Conf Panel Video
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsCHAR(16) Conference was a live conference in NYC held on 6 Dec 2016, focusing on Scalability for Business. The Speaker Panel was recorded, so you can find out what happened here: http://youtu.be/eLjBoZr4dTc (1 hour) Eric David Benari hosted an hour long “chat show” format, featuring Mason Sharp Petr Jelinek Peter Eisentraut Simon Riggs Jonathan Katz […]
The PostgreSQL License – What Does It Mean For My Business?
/7 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidWhen I talk to various people about PostgreSQL, based on where they are in the process of analyzing it, I get asked many similar questions. One of the most frequently asked questions is: What is the PostgreSQL licensing model? Here is my attempt to address this question from the perspective of what the PostgreSQL license […]
CHAR(16) Scalability for Business
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsCHAR(16) Conference (now known as 2QPGConf) on Scalability for Business went very well in the heart of New York City. Hotel Pennsylvania was a great venue; convenient for travel and a great conference venue with coffee, food and evening drinks. Jonathan Katz was great as MC for the conference, while Eric David Benari did a great job […]
Avoiding Disasters in New York
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsWhat to do when disaster strikes… (various topics) King Kong attacks! Lure up tall building and attack with biplanes Godzilla’s eggs hatch Team up with European Special Forces operative to escape, then call in airstrike on Madison Square Gardens Watch the Rangers lose at home (same as above) Global Warming descends quickly Stay holed up […]
On the impact of full-page writes
/20 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraWhile tweaking postgresql.conf, you might have noticed there’s an option called full_page_writes. The comment next to it says something about partial page writes, and people generally leave it set to on – which is a good thing, as I’ll explain later in this post. It’s however useful to understand what full page writes do, because […]
PostgreSQL Meetup in Melbourne, Australia
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniIf you live in the Melbourne area and you are passionate about PostgreSQL then don’t miss the chance to come to the Melbourne PostgreSQL Users Group Meetup this Monday, 21 November.