Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

PostgreSQL releases?

April 26, 2017PostgreSQL releases

0

Posted

PostgreSQL releases?

1 Answer

0

Posted

418418 419 The PostgreSQL team makes only small changes between minor releases, 420 so upgrading from 7.4.0 to 7.4.1 does not require a dump and restore. 421 However, major releases (e.g. from 7.3 to 7.4) often change the 422 internal format of system tables and data files. These changes are 423 often complex, so we don’t maintain backward compatibility for data 424 files. A dump outputs data in a generic format that can then be loaded 425 in using the new internal format. 419 The PostgreSQL team makes only bug fixes in minor releases, so, for 420 example, upgrading from 7.4.8 to 7.4.9 does not require a dump and 421 restore; merely stop the database server, install the updated 422 binaries, and restart the server. 423 424 All users should upgrade to the most recent minor release as soon as 425 it is available. While every upgrade has some risk, PostgreSQL minor 426 releases are designed to fix only common bugs with the least risk. The 427 community considers not upgrading more risky t