planet.postgresql.org

Euler Taveira de Oliveira: Postgres Object ownership

Sometimes I have to fix some object ownership such as tables and views. Let's figure out if there is such object in your database:---- list tables, views, foreign tables and sequences not owned by role postgres--SELECT n.nspname AS SCHEMA, c.relname AS relation, pg_get_userbyid(c.relowner) AS ROLE, 'ALTER TABLE ' || quote_ident(nspname) || '.' || quote_ident(relname) || ' OWNER TO postgres;' AS commandFROM pg_class cINNER JOIN pg_namespace n ON (c.relnamespace = n.oid)WHERE nspname !~ '^pg_' AND nspname <>...

planet.postgresql.org

Daniel Vérité: Nondeterministic collations

Since version 12, PostgreSQL collations are created with a parameter named deterministic, that can be true or false, so that collations are now either deterministic (which they are by default), or nondeterministic. What does that mean? This term refers to what Unicode calls deterministic comparisons between strings: This is a comparison where strings that do not have identical binary contents (optionally, after some process of normalization) will compare as unequal So before version 12, comparisons for collatable types in Postgres are always...

planet.postgresql.org

Alexey Lesovsky: Freshly baked PostgreSQL 12 and changes it brought to pgCenter

PostgreSQL 12 release is expected today and just by looking at the prerelease notes this release is impressive - features added in the previous versions, became more “tasty”.As pgCenter developer I am mainly interested in features related to monitoring and activity statistics. Postgres 11 didn’t have prominent monitoring features, but the upcoming release has several of these. In this post I will review these novations and show how they were implemented in pgCenter.As you can remember, in Postgres 10 a new progress tracking view was...

planet.postgresql.org

Peter Bengtsson: Update to speed comparison for Redis vs PostgreSQL storing blobs of JSON

Last week, I blogged about "How much faster is Redis at storing a blob of JSON compared to PostgreSQL?". Judging from a lot of comments, people misinterpreted this. (By the way, Redis is persistent). It's no surprise that Redis is faster. However, it's a fact that I have do have a lot of blobs stored and need to present them via the web API as fast as possible. It's rare that I want to do relational or batch operations on the data. But Redis isn't a slam dunk for simple retrieval because I don't know if I trust its integrity with the...

planet.postgresql.org

Bruce Momjian: Implementing Transparent Data Encryption in Postgres

For the past 16 months, there has been discussion about whether and how to implement Transparent Data Encryption (TDE) in Postgres. Many other relational databases support TDE, and some security standards require it. However, it is also debatable how much security value TDE provides. The TDE 400-email thread became difficult for people to follow, partly because full understanding required knowledge of Postgres internals and security details. A group of people who wanted to move forward began attending a Zoom call, hosted by Ahsan Hadi. The...

planet.postgresql.org

Robert Treat: Introducing phpPgAdmin 7.12.0

After an overly long development cycle, I'm pleased to introduce the latest release of phpPgAdmin, version 7.12.0. As with many software releases, the code changes are plenty, and the release bullets are few, but they are quite important. In this release we have: PHP 7 is now the default version for development, and the minimum version required for phpPgAdmin going forward. Most users are currently running PHP 7, so we're happy to support this going forward, and encourage users of PHP 5.x to upgrade for continued support. We've added support...

planet.postgresql.org

Robert Haas: Synchronous Replication is a Trap

Almost ten years ago, I wrote a blog post -- cautiously titled What Kind of Replication Do You Need? -- in which I suggested that the answer was probably "asynchronous." At that time, synchronous replication was merely a proposed feature that did not exist in any official release of PostgreSQL; now, it's present in all supported versions and has benefited from several rounds of enhancements. Demand for this feature seems to be high, and there are numerous blog posts about it available (EnterpriseDB, Cybertec, Ashnik, OpsDash), but in...

planet.postgresql.org

Nawaz Ahmed: PostgreSQL Top Learning & Training Resources

Oftentimes, people want to know about “That One Place” to get all their learning and training resources for PostgreSQL. When I get such a question from a colleague, my typical response it to tell them to look it up online. But I know as soon as they hit the “.com” highway, they will be confronted with a barrage of resources about PostgreSQL from blogs, articles, whitepapers, videos, webinars, cookbooks for dummies, cheat sheets, and more. In this blog, I am going to take you on a journey of some of the important avenues to quickly...