Waiting for PostgreSQL 19 – Add non-text output formats to pg_dumpall
Read OriginalThe article details a new feature in PostgreSQL 19 where pg_dumpall can now output in custom, directory, or tar formats, not just plain SQL. This allows for parallel restores, selective restoration of individual databases, and better handling of global objects like roles. It includes performance comparisons and file structure examples of the new dump formats.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser
Top of the Week
1
Webinar Series – SQL Server Indexing
Koen Verbeeck
•
1 votes
2
Risks and Limitations of AI in the Life Sciences
Jeremy Howard
•
1 votes
3
1M context is now generally available for Opus 4.6 and Sonnet 4.6
Simon Willison
•
1 votes
4
AI is my CMS
Chris Coyier
•
1 votes
5
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane
•
1 votes
6
LLM Use in the Python Source Code
Miguel Grinberg
•
1 votes