I’ve always loved PostgreSQL. It is my database of choice these days and I use it with both CakePHP and with the Django framework for Python. PostgreSQL has always had a very robust feature set and was one of the first truly ACID compliant open source databases. With the recent release of version 9, PostgreSQL has added a slew of requested features that truly put it above the rest. The biggest new feature in Postgres 9.0 is streaming replication. As many have noted, third party solutions for this have existed for some time but now there is an “official” solution that ships with the Postgres server. This streaming replication allows one or more databases to be replicated from a master server. It’s an asynchronous transfer but very quick. In addition to the new streaming replication, Postgres 9.0 also features a hot standby ability. This allows a secondary database to be designated as a hot standby should the primary database fail. In addition, the hot standby can be used as a read only database while the primary database is active. This allows for some level of load balancing and brings PostgreSQL closer to the ability to support active-active configurations. Another big new feature is the addition of an in-place upgrade. Previously, when upgrading from one major version of PostgreSQL to another, you had to run pg_dump and export all your data. Then the database server would be upgraded and all the data had to be re-imported. This was typically due to changes in the way the data was stored on disk or other incompatible changes. The new in-place upgrade feature eliminates these extra steps which will make it much easier to upgrade Postgres in the future. Read more: LearnComputer
Posts
0 comments:
Post a Comment