Each new major release of PostgreSQL comes with many new and exciting features, security enhancements, and performance improvements. But, what specific performance gains are seen when upgrading outdated database clusters...
After releasing OAuth2 support, pgAdmin introduced OAuth2 scope configuration. Initially, we supported only 2 scopes, i.e. profile and email, now users can configure as many as scopes with OAUTH2_SCOPE parameter.
One way that you can make a PostgreSQL role very powerful is to give it the CREATEROLEproperty, either by creating it using a command like CREATE USER alice CREATEROLE, or...
First we have the bare bones of the PostgreSQL Interval, Date and Timestamp Data types. Here are the questions: What types are they? And what options do they have? What...
‘Tis the season for giving, celebration and the chance to reflect on everything that’s made 2022 a successful year. That’s why—with the holidays around the corner—EDB created the “ 12...
Moving databases to the cloud is currently one of the most popular IT activities in enterprises around the world. According to Gartner, spending on cloud databases is outpacing on-premises spend...
Learn how leaving Oracle for Postgres specifically benefits developers, what considerations and concerns developers might have about the process of migration and the best solutions to ensure a seamless migration...
Best practices that Postgres administrators and users can employ to ensure they don’t become the next PII horror story. Not only will we discuss how to prevent the specific instance...
