security

This tag is associated with 3 posts

Challenges of Postgres Containers

Posted by Jeremy ⋅ December 31, 2024 ⋅ Leave a comment

Many enterprise workloads are being migrated from commercial databases like Oracle and SQL Server to Postgres, which brings anxiety and challenges for mature operational teams. Learning a new database like Postgres sounds intimidating. In practice, most of the concepts directly transfer from databases like SQL Server and Oracle. Transactions, SQL syntax, explain plans, connection management, … Continue reading →

Paranoid SQL Execution on Postgres

Posted by Jeremy ⋅ July 6, 2021 ⋅ 1 Comment

Suppose that you want to be completely over-the-top paranoid about making sure that when you execute some particular SQL statement on your Postgres database, you’re doing it in the safest and least risky way? For example, suppose it’s the production database behind your successful startup’s main commercial website. If anything even causes queries to block/pause … Continue reading →

Patching Time

Posted by Jeremy ⋅ October 15, 2014

Just a quick note to point out that the October PSU was just released. The database has a few more vulnerabilities than usual (31), but they are mostly related to Java and the high CVSS score of 9 only applies to people running Oracle on windows. (On other operating systems, the highest score is 6.5.) … Continue reading →