postgresql8.5alpha3可以下载使用了,可以热备份了,内置主从复制方案

最新推荐文章于 2025-07-16 08:52:01 发布

阅读量108

点赞数

PostgreSQL 8.5 Alpha3 版本发布，新增热备功能，支持只读连接，在恢复期间即可实现主从复制。此外还引入了排除约束等新特性，增强逻辑数据完整性。此版本主要用于开发测试，不适合生产环境。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在postgresql官方网站上发现了 postgresql8.5 alpha3的消息,看了一下新功能说明,真是又激动了一下
地址
[url]http://www.postgresql.org/about/news.1172[/url]
第一项就够大家高兴的:我想开发postgresql的学院派大牛们也渐渐了解了企业用户的心声,数据库外围功能是绝不能忽视的.
我激动一下 :idea:

第一项:热备份,内置了主从复制方案,在恢复数据库时可以只读访问,下面的还得慢慢看.
另外这个版本是不能用于线上业务的,只能开发测试,不能真正使用.

另外文档:http://developer.postgresql.org/pgdocs/postgres/release-8-5.html
下载:http://www.postgresql.org/ftp/source/8.5alpha3/

参考新功能列表:
Features added in alpha3 include:

* Hot Standby, allowing read-only connections during recovery, provides a built-in master-slave replication solution.
* Exclusion constraints, a generalized version of unique constraints, offer novel ways to guarantee logical data integrity.
* SQL standard conforming ORDER BY within aggregate function calls, removes the need for ugly workarounds to get ordered aggregate function input.
* Access control for large objects was added.
* Regular expression functions support case-insensitive matching and locale-dependent character classification when the server encoding is UTF8.
* PL/pgSQL is installed by default.
* The PL/pgSQL parser has been reworked to behave much more sanely.
* Various improvements were made in PL/Perl and PL/Python.