~postgresweekly | Bookmarks (3)

Announcing PL/.NET 0.99: A Public Beta Release — pl/dotnet adds full support for C# and F# to Postgres (like this). If you're in the .NET space, they want you to kick the tires a bit ahead of a final 1.0 release. GitHub repo.

pg_dumpbinary v2.15: Dump a Postgres Database to Binary Format — Rather than produce a SQL dump, this produces a binary one (which can be restored by the accompanying pg_restorebinary tool). There are various edge cases where a binary dump may be preferable, such as when using (very) large bytea columns or custom types that use \0 values that can break standard dumps.

PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released — All supported versions get updates to fix a variety of bugs, as well as a security vulnerability where the owner of a materialized view could get a higher privileged user to run code associated with that view at their higher level (now all user-determined code is run as the view’s owner, as it’s meant to be).