Blog Posts by Dave Page

Blog Posts by Dave Page's picture

About Dave Page

Dave has been actively involved in the PostgreSQL Project since 1998, as the lead developer of pgAdmin, maintainer of the PostgreSQL installers and one of the projects resident Windows hackers. He also serves on the project's web and sysadmin teams and is a member of the PostgreSQL Core Team. Dave is employed by EnterpriseDB where he works as a software architect and developer on EnterpriseDB products in addition to his community PostgreSQL work.

I've been asked a few times recently for my opinion on VoltDB , the new database server architected by the 'father' of Postgres, Dr Michael Stonebraker so rather than repeating myself over and over again it seems like a good idea to write it all down.Read more
A cornerstone of the Management Suite in the EDB Postgres Platform is EDB Postgres Enterprise Manager (PEM). The suite provides key management, monitoring, and development capabilities. PEM is designed for monitoring and managing both small and large fleets of PostgreSQL and EDB Postgres Advanced...Read more
When it comes to enterprises deciding on whether to adopt open source software or commercial software based on open source it can lead to fierce debate about the relative merits of these different approaches. EnterpriseDB ® (EDB™) provides a data management platform based on the open source project...Read more
If you've ever used one of the PostgreSQL installers for v8.2 or above, either the old Windows MSI installer or the newer "one click" installers that also support Linux and Mac, you'll probably have come across StackBuilder. For those that haven't or those that never found the time, StackBuilder...Read more
So having spent the last few months with my head buried deep in a project at work, I finally managed to get back to my previous hacking on SQL/MED at the weekend after the kids went away for a week (good $DEITY it's quiet here)! Within a couple of hours, I had my half-baked Foreign Data Wrapper for...Read more
By far the most common issues we see reported with the "one-click" PostgreSQL installers that we build here at EnterpriseDB are password related. In this post I'll explain what the passwords are, why we need them, and how to reset them. Superuser PasswordRead more
A colleague of mine (thanks Jimbo!) pointed me towards a benchmark comparison of Postgres 8.3.8 on RHEL 5.4 versus SQL Server 2008 R2 on Windows Server 2008 R2, performed and written up by Red Hat. I hadn't seen it before, so figured that maybe others hadn't either: more
As you may know, many of us from the pgAdmin team have been hard at work on pgAdmin 4 for some time now. pgAdmin 4 is a complete rewrite of pgAdmin (the fourth, as you may guess), the previous version having reached the end of it's maintainable life after 14 years of development. Work on the...Read more
I’m often asked how I first became involved in PostgreSQL , and how the pgAdmin project got started. Much as I’m happy to tell the story over beer, it becomes tedious to do so over email after the first half-dozen or so times. So in a vain attempt to save my fingers from future carpal tunnel syndrome, here’s the tale...Read more
The world in which PostgreSQL operates today is very different from its origins in 1986. Where once PostgreSQL might have been considered an academic exercise even following its initial Open Source release, today it operates in a much more dynamic environment. Open source and traditional commercial...Read more
After 9 months of heads-down work, I'm glad to finally be able to talk about the project I and a number of colleagues here at EnterpriseDB have been working on... Introducing Postgres Enterprise Manager ! Postgres Enterprise Manager, or PEM as we tend to call it, is based on the Open Source pgAdmin...Read more