Postgres 17 added a builtin locale provider that removes the external dependency entirely:
initdb --locale-provider=builtin --locale=C.UTF-8
This change helps sorting to become stable across OS upgrades. glibc is still the default in Postgres 18, so this must be specified when creating a new cluster.
For clusters already running: Postgres 13+ will log a warning when a collation version changes. That warning is an instruction to rebuild affected indexes.
Get more details here in this week's PG Phriday blog post from Shaun Thomas: https://www.pgedge.com/blog/what-is-a-collation-and-why-is-my-data-corrupt
We're looking for feedback on our (100% open-source) MCP Server for PostgreSQL, designed by the creator of pgAdmin (https://github.com/pgEdge/pgedge-postgres-mcp).
What works well? What would you love to see added as new features? Tell us your thoughts in the following survey link, & you'll be entered to win from there: https://pgedge.limesurvey.net/442899
Don't forget to star the repository to keep an eye out for new features - the project is under active development, and more are coming.
Giveaway ends 11:59 PM EST 3/31, winner announced 4/1!
...all from a recognized, 100% Postgres focused vendor with enterprise SLAs.
Try it out on GitHub: https://github.com/pgEdge/pgedge-postgres-mcp
To win a brand new CanaKit Raspberry Pi 5 Starter Kit PRO - Turbine Black, 128GB Edition and 8GB RAM (with free shipping), give it a try and leave us feedback here for an entry (ends March 31, winners announced April 1): https://pgedge.limesurvey.net/442899
Don't forget to leave a star to the GitHub repo to keep an eye for future releases - new features being dropped often with active development to the project.
...all from a recognized, 100% Postgres focused vendor with enterprise SLAs.
Try it out on GitHub: https://github.com/pgEdge/pgedge-postgres-mcp
To win a brand new CanaKit Raspberry Pi 5 Starter Kit PRO - Turbine Black, 128GB Edition and 8GB RAM (with free shipping), give it a try and leave us feedback here for an entry (ends March 31, winners announced April 1): https://pgedge.limesurvey.net/442899
Don't forget to leave a star to the GitHub repo to keep an eye for future releases - new features being dropped often with active development to the project.
We've also created an open source MCP server FOR PostgreSQL (works with any greenfield app or existing database) called pgedge-postgres-mcp (https://github.com/pgEdge/pgedge-postgres-mcp) - questions & feedback are very welcome here as well.
This February, there'll be a webinar scheduled with the engineer behind the project. He'll be answering questions, both ones asked here in this thread and ones asked at the end of the session during a Q&A.
Keep an eye out here for it to be scheduled: https://www.pgedge.com/webinars
Let's make this interesting for everyone - reply or reach out to community (at) pgedge.com if you have a question or feedback
Come by the DRW and say hi: https://www.meetup.com/illinois-prairie-postgresql-user-group/events/312929674/