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

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

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

另外文档: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.

评论

3 楼 wangshare 2010-01-15  

毕竟是学院派的作品，
再不思进取，postgresql的用户们要心凉了

2 楼 Magicloud 2010-01-15  

终于有数据库热备了么……这群不思进取的混蛋。
以前不是信誓旦旦地说pgsql够好了，功能添加出于爱好么！

1 楼 wangshare 2010-01-14  

英文能力很有限,靠着nciku.com来翻译.

很高兴请大家来斧正.


Features added in alpha3 include:
在阿尔法3版本中增加功能如下:

* 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.
在聚合函数调用下的ORDER BY符合了sql标准(或者说和sql标准一致)，去除了一些丑陋的解决方法的需求,然后采用有序聚合函数的输入的方式.[这个没弄清楚,我自己觉得翻译得不对路 ,请大家斧正斧正]


* 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.
在UTF8编码的服务器下,正则表达式函数支持大小写匹配(就是不区分大小写了),而且还支持区域相关字符串的分类(这个倒要好好瞧瞧)

* PL/pgSQL is installed by default.
默认装pl/psql(谁都知道,貌似鸡肋)

* The PL/pgSQL parser has been reworked to behave much more sanely.
PL/pgSQL的解释器重写了,执行起来更清晰了(那意思就是说出了问题不再乱指了,能说明白了)

* Various improvements were made in PL/Perl and PL/Python.
对PL/Perl 和 PL/Python 进行了各种优化.(哪些优化不知道)