» database

Learn how to effectively configure PostgreSQL log management for troubleshooting performance problems.

https://www.2ndquadrant.com/en/blog/how-to-get-the-best-out-of-postgresql-logs/

Don’t make people practice software archaeology – keep your system updated. Updates? One of the benefits of the open-source world is the unmatched ability to issue updates rapidly to correct ...

https://www.2ndquadrant.com/en/blog/keep-your-libraries-updated-and-nobody-gets-hurt-skip-library-updates-trigger-breakages/

A regular expression is a special text string used to describe a search pattern. PostgreSQL’s regular expressions supports three separate approaches to pattern matching: POSIX-style regular exp...

https://www.2ndquadrant.com/en/blog/postgresql-regular-expressions-and-pattern-matching/

Spectre and Meltdown have caused severe alarm in recent days. You may have read about up to 30% impact on PostgreSQL databases, which I believe to be overstated because of misunderstandings in th...

https://www.2ndquadrant.com/en/blog/postgresql-meltdown/

Some years ago, I prophesized that PostgreSQL would win in the end, and that we would be able to tell because there would be “Microsoft PostgreSQL”. I am happy to report that has now happened...

https://www.2ndquadrant.com/en/blog/postgresql-popularity-continues-to-grow/

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 u...

https://www.2ndquadrant.com/en/blog/barman-2-1and-the-new-archive-option/

This 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 re...

https://www.2ndquadrant.com/en/blog/pgday-it-2016/

When 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 ...

https://www.2ndquadrant.com/en/blog/the-postgresql-license-what-does-it-mean-for-my-business/

PostgreSQL 9.6 has just been released and most of the postgres users will start asking themselves how to upgrade to the new major version. This post has the intention of showing different procedu...

https://www.2ndquadrant.com/en/blog/untangling-the-postgresql-upgrade/

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog posts. T...

https://www.2ndquadrant.com/en/blog/evolution-fault-tolerance-postgresql-synchronous-commit/

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog posts. T...

https://www.2ndquadrant.com/en/blog/evolution-of-fault-tolerance-in-postgresql-time-travel/

Last week, 2ndQuadrant‘s Gabriele Bartolini was privileged to speak at IBM Italia’s Open Innovation event in Milan, Italy. At this event, IBM highlighted the strengths of open source such as ...

https://www.2ndquadrant.com/en/blog/working-together-to-create-an-open-source-world/

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog posts. T...

https://www.2ndquadrant.com/en/blog/evolution-of-fault-tolerance-in-postgresql-replication-phase/

Version 1.6.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman is now able to receive WAL files via streaming replication protocol, as an additional channel (not y...

https://www.2ndquadrant.com/en/blog/announcing-barman-1-6-0/

The 3rd annual Nordic PGDay will be held on 17th of March in Helsinki this year. Registration is still open, reserve yourselves a seat before it’s too late! Nordic PGDay is visiting a different...

https://www.2ndquadrant.com/en/blog/are-we-ready-for-nordic-pgday/

Ansible Galaxy is simply the easiest way of finding already written Ansible roles, creating and sharing your roles and jump into the galaxy of Ansible content! ==================== Prime time ann...

https://www.2ndquadrant.com/en/blog/postgresql-planet-in-ansible-galaxy/

2ndQuadrant is proud to announce the release of version 1.5.1 of Barman, Backup and Recovery Manager for PostgreSQL. This minor release introduces support for ‘per-server’ concurrency of main...

https://www.2ndquadrant.com/en/blog/announcing-barman-1-5-1/

Version 1.5.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman is now able to return upon request any available WAL file for a given server, allowing DBAs to integ...

https://www.2ndquadrant.com/en/blog/announcing-barman-1-5-0/

The release of PostgreSQL 9.5 is imminent so the time has come to analyse what’s new in this latest version. A very interesting feature of version 9.5 is the ability to import a schema from a r...

https://www.2ndquadrant.com/en/blog/postgresql-9-5-import-foreign-schema/

The 1.4.0 version of Barman adds new features such as incremental backup and automatic integration with pg_stat_archiver which aim to simplify the life of DBAs and system administrators. Barman 1...

https://www.2ndquadrant.com/en/blog/whats-new-barman-1-4-0/

The 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data, allowing PostgreSQL to be competitive in managing the “lingua franca” of the momen...

https://www.2ndquadrant.com/en/blog/jsonb-type-performance-postgresql-9-4/

The introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQL” side of this relational DBMS come out: this introduction meets the requirements of all those who prefer a d...

https://www.2ndquadrant.com/en/blog/nosql-postgresql-9-4-jsonb/

Version 1.3.3 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman is now able to send alerts in case the latest available backup for a server is older than a given ti...

https://www.2ndquadrant.com/en/blog/announcing-barman-1-3-3/

Version 1.3.1 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman now supports concurrent backup from PostgreSQL 9.2 and 9.3 servers, using the pgespresso extension, ...

https://www.2ndquadrant.com/en/blog/announcing-barman-1-3-1/

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 comm...

https://www.2ndquadrant.com/en/blog/announcing-barman-1-3-0/