In February of 2010, the United States Government first introduced the Cloud First Policy. Its goal was to push government services towards third party cloud computing services that could provide a host of benefits over the software stacks and services that were (and often still are) in place.

Database Management Systems uses MVCC to avoid the problem of Writers blocking Readers and vice-versa, by making use of multiple versions of data. There are essentially two approaches to multi-version concurrency.

With the most recent release of Postgres Plus Advanced Server 9.4, EnterpriseDB (EDB) has also upgraded our database enterprise management console, Postgres Enterprise Manager (PEM). The new PEM 5.0 delivers all the enterprise-class tools necessary for DBAs and Developers to easily administer, monitor and tune large Postgres deployments from a single graphical console.

Advances in Postgres in recent releases have opened up opportunities for expanding features that support data integration. The most compelling of these new features are called Foreign Data Wrappers (FDWs).

The newest release of Postgres Plus from EDB is a serious game changer for DBAs and organizations running mixed workloads on their mission critical systems. Postgres Plus Advanced Server 9.4 now features the ability to prioritize enterprise workloads to prevent a single job or group of jobs from monopolizing system CPU or I/O resources and harming the performance of more important jobs.

When a well-prepared DBA begins to consider their Postgres rollout, they should think about their database strategy sooner rather than later. Thinking about key database variables and questions in advance will give you the inside knowledge you need to make you the IT hero as you reveal a solid deployment plan that directly supports the goals of the business.

This story is playing out all over web. You have a successful web application that you’re hosting on a system that can’t keep up with the application’s growth. You know the cloud offers flexibility and scalability that will allow your application to adapt to the growth. However, you’re concerned that moving the application will be risky and interrupt the service that your customers depend on.

Before you begin a Postgres deployment, it is crucial to think about your database strategy sooner rather than later. Neglecting to do so can result in misallocated resources, limited ability to change, or worse, critical data loss as a result of an outage or disaster.

The EDB Backup and Recovery Tool (BART) is an administrative utility providing simplified backup and recovery management for multiple local or remote Postgres Plus Advanced Server and PostgreSQL database servers. Managing backups of your important business data and the speedy recovery of your data in case of an incident is critical for any organization. The process of taking backups and performing...

This blog was co-written by Ibrar Ahmed. Postgres provides a powerful feature called Foreign Data Wrappers (FDW), which enables DBAs to use the system as a single integration point to read, analyze and write to data from many remote data stores. Developers working in C can create new FDWs using the hooks exposed by the database, and many FDWs have been published in the Open Source community. FDWs...