C #, .NET, Java, Php, Python, Wordpress, Windows, Linux…

And’ Release the new version of the open source database PostgreSQL .

In this version there are important and interesting features such as synchronous replication Now that is asynchronous by default, avoid data loss. Specifically, if the primary server crashed then some operations that have been confirmed have not yet been replicated to the standby server, can cause data loss. The amount of data loss is proportional to the delay replication when failover. This level of protection is referred to as 2-safe replication in the theory of computing.

Serializable snapshot isolation provide isolation of transactions closely, This level emulates serial transaction execution, as if the transactions were executed one after the other, serial, rather than concurrently.

Support of per-column collations allows you to specify the sort order and character of the behavior classification of data by column, or operating. This relieves the restriction that LC_COLLATE and LC_CTYPE settings of a database prevents the change after its creation.

Foreign wrappers and given support and permission control SELinux and many other things. The complete list of the changes are that.

PostgreSQL has always had characteristics of strength and was the first database open source to have passed the test ACID, which is a sign of professionalism. With the recent release of 9, PostgreSQL has added many requested features that really put him above the average of the database.

The biggest news of PostgreSQL 9.0 is the replication stream. Existed for some time third-party solutions for this feature, but now there is a solution “Journal” that comes with the Postgres server. Streaming allows replication to one or more databases to replicate from a master server to secondary servers atria. This is an asynchronous transfer, but very fast.

In addition to the new replica streaming, Postgres 9,0 There is also a hot standby capacity. This allows a secondary database to be designated as a hot standby in case the primary database fails. In addition, The hot standby can be used as a read-only database, while the primary database is active. This allows a certain level of load balancing and PostgreSQL port closest to the ability to support active-active configurations.

Read more…