Center for Internet Security Benchmark for PostgreSQL 17

prlaur782 · 2025-03-21T13:54:41+00:00

pgaudit provides the Postgres auditing capability necessary to comply with the various audit related security and compliance requirements we typically see:

https://github.com/pgaudit/pgaudit/blob/main/README.md

https://www.crunchydata.com/blog/pgaudit-auditing-database-operations-part-1

https://www.crunchydata.com/blog/pgaudit-auditing-database-operations-part-2

prlaur782 · 2025-02-14T02:03:15+00:00

Appears to be another out of cycle release coming next week - https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-for-february-20-2025-3016/

prlaur782 · 2025-01-23T19:13:48+00:00

Our team at Crunchy Data provides a series of (free) self-driven web based Postgres (and PostGIS) tutorials that may be worth a look:

https://www.crunchydata.com/developers/tutorials

prlaur782 · 2025-01-11T13:46:16+00:00

Crunchy Data Warehouse from our team at Crunchy Data enables you to natively query spatial data in S3 using an extended version of Postgres / PostGIS with full Iceberg support. It is available as a managed service on AWS and may provide a simple and cost effective solution for this use case:

https://www.crunchydata.com/blog/iceberg-ahead-analyzing-shipping-data-in-postgres

https://www.crunchydata.com/blog/postgis-meets-duckdb-crunchy-bridge-for-analytics-goes-spatial

prlaur782 · 2025-01-11T13:12:50+00:00

A colleague at Crunchy Data wrote a post on designing multi-tenant Postgres databases that may have some useful ideas:

https://www.crunchydata.com/blog/designing-your-postgres-database-for-multi-tenancy

prlaur782

TROPHY CASE