Bases de donnéesPlanet PostgreSQL
Bases de données
PostgreSQL's GSSAPI authentication relies on two server-wide settings: `krb_server_keyfile` points to a dedicated keytab file (never share the system one), and…
lo_compat_privileges sets large-object security back to PostgreSQL 8.4, the last release in which a large object belonged to nobody in particular and any role that could connect to the database could read it, overwrite it, or delete it.…
The PostGIS development team is pleased to provide postgis_tiger_geocoder extension. This is the very second release since the break from the PostGIS core. This version requires PostgreSQL 16 and above and should work with any supported…
How to tell if your slow Postgres query is a planning or execution problem: read EXPLAIN ANALYZE's Planning Time and Execution Time to diagnose the bottleneck.