EnterpriseDB Webinar: 5 Postgres DBA Tips from Dave Page You Don’t Want to Miss

Date: Thursday, October 20, 8:00am EDT

Register for this special webinar to learn from the father of pgAdmin and EDB Postgres Enterprise Manager, Dave Page, how to efficiently manage your Postgres databases.

The daily life of a DBA can be tough – especially when many tasks are performed manually. That is why smart DBAs are looking for good tools to help them manage their databases more efficiently.

When working with Postgres the must-have tool is pgAdmin or EDB Postgres Enterprise Manager (PEM) depending on your needs. While pgAdmin helps with simple tasks like creating a database, running SQL, or checking the status of the server, PEM offers those and more, such as advanced functionality for 24×7 monitoring, management and tuning.

During this presentation Dave Page, lead developer of pgAdmin and Vice President and Chief Architect, Tools and Installers, at EnterpriseDB, will introduce the following functionalities of pgAdmin and PEM:

  • Examining the performance of a query using the explain plan visualizer in pgAdmin’s Query Tool
  • Examining the performance of a process or session consisting of multiple queries in PEM’s SQL Profiler
  • 24/7 monitoring of Postgres and the underlying host system
  • Capacity management and reporting
  • Alerting the DBA or System Administrator to potential problems

Join this webinar to watch pgAdmin and PEM in action and learn how to make your life as a DBA a lot easier.

Target Audience: This presentation is intended for DBAs who are responsible for the administration of Postgres databases, as well as developers who use Postgres for their applications. Participants will learn how pgAdmin and EDB Postgres Enterprise Manager help users to gain confidence and efficiency working with Postgres.

*This presentation is not intended to be formal PostgreSQL DBA training. All EDB webinars are free and the recording will be sent to every registrant.

Webcast Author:

Dave Page, Lead Developer of pgAdmin, PostgreSQL Community, VP & Chief Architect, Tools and Installers, EDB

Register Here

Duration: 1 hour

PostgreSQL 9.6 is Now Available

New Community Version of PostgreSQL 9.6 Boosts Performance with Parallel Query and Vertical and Horizontal Scalability Features

BEDFORD, Mass. – September 29, 2016 EnterpriseDB, the leading enterprise Postgres database company, congratulates the PostgreSQL Global Development Group for the newly released PostgreSQL 9.6. The new 9.6 version features parallel processing capabilities and expands scale up and scale out capacity to support more complex workloads and data infrastructures distributed across multiple or remote data sources.

Members of EDB’s staff worked as part of the PostgreSQL Community to develop performance advances for PostgreSQL 9.6 that will extract greater efficiency from todays hardware for larger and more complex workloads,” said Marc Linster, Senior Vice President, Product Development. “Based on contributions from EDB and the community at large, PostgreSQL 9.6 will benefit EDB customers that require parallel processing.

Advances in PostgreSQL 9.6 move the database deeper into analytics, addressing long-time bottlenecks that have made it difficult to run PostgreSQL on larger data sets. Enhancements to the freeze map, for example, allow PostgreSQL to scale up further than ever before, while new parallel query facilities make it possible to use multiple CPU cores to accelerate response times for queries that touch a lot of data. Expanded replication capabilities make it possible to build a truly reliable multi-node read scaling cluster based on PostgreSQL. Full-text searching enhancements help make PostgreSQL more effective with document stores and now supports the ability to search for words based on proximity, which helps lexical and forensic applications.

Scalability Enhancements

Scalability enhancements to PostgreSQL 9.6 that improve performance include:

Parallel Sequential Scans, Joins, and Aggregates: These features improve query performance on today’s multi-core servers by enabling PostgreSQL to utilize multiple cores in a server. This improves query performance on today’s increasingly powerful hardware, particularly for CPU-intensive queries that benefit from using all cores on a server. These vertical scalability, or scale up, features are an important advance for PostgreSQL and will support the development of more advanced parallel processing capabilities in later releases.

Enhancement to Freeze Map using Autovacuum: PostgreSQL’s Freeze Map features track data blocks that do not require vacuuming, thereby avoiding unnecessary multiple scans of data. This scale up enhancement saves I/O overhead and results in more efficient use of hardware for greater overall performance and scalability.

Support for Remote Joins, Sorts, and Updates in Postgres_fdw: The Foreign Data Wrapper (FDW) feature in PostgreSQL that links the database to external data sources, has been enhanced to increase query performance when it is used to connect multiple Postgres databases. postgres_fdw can now “push down” some query logic to remote servers to better distribute workloads, and use the foreign database server to perform the query operations. With this predicate push down of sorts, joins, and batch data updates, users can distribute workloads across multiple servers, and expand the database’s horizontal, or scale out, capacity.

Synchronous Replication Enhancements: Synchronous replication now allows multiple synchronous standbys that have the option to wait for transactions to be applied (rather than received). This allows better consistency across database clusters and expands horizontal scalability for read-only transactions to identical replicas. This also improves disaster recovery architectures.

DBA Features

PostgreSQL 9.6 also includes several enhancements that assist developers and database administrators:

Full Text Search for Phrases: This feature improves the text search capabilities of PostgreSQL and makes it a better alternative to dedicated text search technologies that some companies use to search the web and mine data.

Exposed Wait States: An improved pg_state_activity system view more effectively supports troubleshooting and helps DBAs diagnose problems with queries and resolve issues.

EDB Contributions

EDB engineers committed over 10,000 hours of development time to the complete rewrite of pgAdmin, the leading graphical open source management, development, and administration tool for PostgreSQL. Working under Dave Page, Vice President, Chief Architect, Tools and Installers at EDB, who is also head of the pgAdmin open source project, EDB engineers rewrote pgAdmin in Python and Javascript/jQuery. The tool can now be run as a standalone on the desktop for a single user or deployed on a web server to support multiple users. For details on changes in pgAdmin 4 and the team that was involved, please read the blog by Dave Page, The Elephant Nears the Finish Line.

EDB is bundling pgAdmin 4 with PostgreSQL 9.6 in its one-click installers of the database.

EDB is honored to have made code contributions to some of the major features in the PostgreSQL 9.6 release. EDB also partners with other companies that work with and use PostgreSQL to drive continual improvement of PostgreSQL, the world’s most advanced open source database.


PostgreSQL 9.6 is now available. To download the free version of PostgreSQL using an easy one-click installer visit the www.postgresql.org community download page. To leverage the full value of PostgreSQL for enterprise deployments, the database also is available as part of the EDB Postgres Standard subscription.

EnterpriseDB Webinar: What’s New in PostgreSQL 9.6 with Bruce Momjian

Date: Tuesday, September 20th, 2016
Time: 8:00am – 9:00am EDT US
Presenter: Bruce Momjian, Co-founder of the PostgreSQL Global Development Team & Sr. Architect at EDB

The PostgreSQL community is rolling out PostgreSQL 9.6 which includes improvements in parallelism for query performance, overall performance improvements and the integration of foreign data sources. Join Bruce Momjian, co-founder of the PostgreSQL Global Development Group and Senior Database Architect, as he introduces the new features of 9.6 and how they will benefit you.

Who Should Attend?

This technical overview is intended for DBAs who are responsible for the administration of Postgres databases, as well as developers who use Postgres for their applications. Participants will learn what’s new in PostgreSQL 9.6 and which use cases might be enabled by these new and improved functionalities.

Register Here

Got Oracle? Got VMware? Going Cloud? You Could Be Stung For Huge Licensing Fees

Story Source and Credit: Gavin Clarke, The Register
First Published: 24th February 2016

Oracle has been telling a number of organisations running its database software that they are breaking the company’s licensing rules – and therefore owe it millions of dollars in unpaid licence fees.

The issue hit the headlines in January after US confectionery giant Mars took Oracle to court in the US over claims Mars had broken the rules. Mars had been audited by Oracle and developed a response plan with compliance specialist Palisade Compliance. The case settled before going to trial.

Dave Welch, chief technology officer and chief evangelist of House of Brick Technologies assessing the case, estimated a $100m spend by Mars on Oracle over a three year period – covering license, software update and support.

Mars was fighting a claim by Oracle that could, conservatively speaking, have doubled that – according to Welch.

But that’s nothing. The Register understands Oracle has gone to customers with claims five times that figure. One contact at a major channel reseller partner told The Reg he is encountering more and more customers running VMs being charged by Oracle for their entire estate.

“Life is very interesting for lots of customers,” our source said.

Not all Oracle database users are at risk; it’s those running Oracle’s premier database in conjunction with VMware’s virtualization software. Given VMware is the largest virtualization spinner and Oracle is the single largest relational database provider, however, the space for conflict in this Venn-style overlap is massive.

The reason Oracle is targeting the VMware base is Oracle does not accept VMware’s world view on licensing, and therefore its definition, of hardware partitioning. An Oracle partitioning document, here, shows Oracle only accepts Solaris Containers, IBM’s LPAR and Fujitsu’s PAR. VMware is not on the list of hard partitioning partners.

Since VMware’s release of vSphere 5.1 in August 2012, Oracle has insisted that you cannot simply license its database to a given number of virtual machines. Rather, you must license your entire server estate, on the basis that you have the potential to run Oracle on all those servers and cores, should you wish.

That could mean servers in the same room or servers in data centres on opposite sides of the world.

The problem is that most VMware users are simply unaware of Oracle’s rules, or are buying into VMware’s definition – and world view – of what’s possible and what’s allowed.

Full Story Here…..

EnterpriseDB’s Tom Kincaid – why did SalesForce.com hire PostgreSQL expert?

Story Source and Credit: Dan Kusnetzky for Virtually Speaking
Originally Published: 28 May 2013

EnterpriseDB’s Tom Kincaid discusses why Salesforce.com hired Tom Lane, well-known contributor in the PostgreSQL community. It could mean many things. What’s clear is that Salesforce.com is embracing the open source database for a very large, enterprise-class workload.

Tom Kincaid, EnterpriseDB’s Vice President, Products and Engineering, and I enjoyed a 30 minute conversation about Salesforce.com’s recent moves to embrace the PostgreSQL open source database. We discussed what the move towards PostgreSQL could mean.

The discussion started with the fact that Salesforce.com has hired a top PostgreSQL community contributor, Tom Lane, and the fact that late last year, Salesforce.com posted a job ad for 40-50 PostgreSQL experts to help build out what was described as “core systems.” Kincaid pointed out that EnterpriseDB employs about a half-dozen key contributors to PostgreSQL.

Here are a few thoughts from the discussion:

  • Salesforce.com, although a major use of Oracle’s database and development software, wants to have a viable alternative. Companies that have a viable alternative can often negotiate better pricing and business terms than those who don’t. Bob Young, former CEO of Red Hat, called this the “Red Hat Discount”.
  • Salesforce, for strategic reasons, wants a second source for important technology. Being reliant on a single source can cause problems. If one source offers better technology at a specific point in time, Salesforce.com’s development efforts can take advantage of that technology.
  • Salesforce.com wants to contribute to the PostgreSQL community and also to help guide the direction of the open source project.

It was a very interesting discussion. I hope I have the opportunity to speak with the good Mr. Kincaid in the future.


AWS Vulnerabilities and the Attackers Perspective

Story Source and Credit: Kyle James, Rhino Security Labs, February 16, 2016

AWS Shortcomings And Security Vulnerabilities

Amazon Web Services (AWS) provides an easy-to-manage cloud platform to store your digital assets, host servers and more. Its simple client interface in tandem with extensive documentation makes it a popular choice amongst developers to host their applications. Amazon also has many settings for security controls including firewalls to block incoming and outgoing traffic and different identity and access management (IAM) accounts with varying levels of privileges. However, misconfigurations in your web application can allow an attacker to pivot into your cloud and exfiltrate both company and consumer data.

Application Permissions – Traditional Vs AWS Options

In the past, developers used hard-coded passwords to access different services, such as MySQL or FTP, to retrieve client data. Amazon realized this poor security practice and implemented what is called the Amazon Metadata Service. Instead, when your application wants to access assets, it can query the metadata service to get a set of temporary access credentials. The temporary credentials can then be used to access your S3 assets and other services. Another purpose of this metadata service is to store the user data supplied when launching your instance, in-turn configuring your application as it launches.

As a developer, you stop reading here – an easily scalable infrastructure with streamlined builds, all of which executing from the command line? Done. If you’re a security researcher, you continue to read the addendum: “Although you can only access instance metadata and user data from within the instance itself, the data is not protected by cryptographic methods.”

AWS “Metadata Service” Attack Surface

From the attacker’s perspective, this metadata service is one of the juiciest services on AWS to access. The implications of being able to access it from the application could yield total control if the application is running under the root IAM account, but at the very least give you a set of valid AWS credentials to interface with the API.

Full Story Here

EnterpriseDB Webinar: Non-Relational Postgres for Creative Developers with Bruce Momjian

Date: Thursday, June 9th, 2016
Time: 8:00am – 9:00am Eastern Time (US), 1:00pm – 2:00pm Eastern Time (US)
Presenters: Bruce Momjian, Co-founder of the PostgreSQL Global Development Team & Sr. Architect at EDB

Postgres is well known as a relational DBMS, but did you know that it supports many non-relational data types including arrays, geometry and JSON for NoSQL use cases? Join Bruce Momjian to learn how you can use these data types to overcome restrictions of relational storage to support new innovative applications, specifically by storing and indexing multiple values, even unrelated ones, in a single database field.

Who Should Attend?

This technical presentation is intended for individuals involved with the development of innovative applications or the design and management of Postgres databases.

Register for Session 1 on June 9 at 8am ET (US)
Register for Session 2 on June 9 at 1pm ET (US)