Jump to content

Author Archive


Installing Postgres Plus Standard Server

Thursday, November 5th, 2009 by Scott Mead

EnterpriseDB has taken Postgres to the next level with Postgres Plus Standard Server.  Standard Server delivers PostgreSQL 8.4, StackBuilder Plus with UpdateMonitor, pre-integrated enterprise modules, value-added enterprise module testing, and enterprise subscription, support, and packaged services. It’s a simple way to install the database engine and all the tools you need in order to get under way.

(more…)

If you're new here, you may want to subscribe to our RSS feed or follow us on Twitter for product announcements, event information, and industry news.

Installing Postgres Plus Standard Server



How to Install Postgres Binaries (in One Click)

Tuesday, November 3rd, 2009 by Scott Mead

In the Linux world, many people have come to rely on (for better or worse) their distribution package management. Personally, I feel that until this is fixed, Linux will never be a mainstream desktop OS. The problem with using your OS package manager for installing Postgres is that there are no real consistency guidelines from vendor to vendor. How do we get around this problem? Simple!

(more …)

How to Install Postgres Binaries (in One Click)



Scaling Postgres Plus Advanced Server in the Cloud

Friday, October 23rd, 2009 by Scott Mead

The idea behind the ‘elastic’ cloud is that you can simply ’stretch’ your wasteband by adding more junk in your trunk, i.e. putting more servers online to give you the ability to scale.  The biggest problem here, however, is the simple fact that Postgres really operates on a ’shared-nothing’ architecture, so how is it that we gain anything by simply adding more resources?  That is, how does Postgres become elastic without changing the application or doing massive architecture work?

Right off the bat, I’ll attempt to eliminate confusion.  The following describes a feature specific to EnterpriseDB’s proprietary product, Postgres Plus Advanced Server, and, specifically, InfiniteCache.

(more…)

Scaling Postgres Plus Advanced Server in the Cloud



How to Monitor a Postgres Warm Standby

Tuesday, September 22nd, 2009 by Scott Mead

Warm standby with Postgres is all the rage nowadays, and the PostgreSQL team has done an incredible job of building an easy to use, robust log shipping / replay system.  Even the newest of users can build a warm standby in just minutes; however, documentation seems to lack questions to the standard set of ‘operational’ questions that users have.  Here, I will nose-dive …

(more…)

How to Monitor a Postgres Warm Standby



Quick and Powerful Database with OpenOffice.org and Postgres

Sunday, July 26th, 2009 by Scott Mead

Unless you’ve been living under a rock for the past 3 years, you’ve heard of OpenOffice.org.  Like most people, I’ve used the software a few times to edit some documents and haven’t really given much thought to it.  During one of my last plane trips, I decided that the small database I keep (in PostgreSQL) needed a facelift, err, well, a face actually.  I built the database completely on the CLI with the postgres ‘psql’ utility and all my access to it is via the CLI.  This is nice, but I figured that there had to be something easier.  I fired up OO.org and started a ‘New Database’ just to see what was possible.  The first screen up gives us the option:

Connect to existing DB via JDBC

I was immediately beside myself with excitement, if OpenOffice base had the ability to draw forms like MS Access, and will let me hook it up to my existing postgres DB, then I may be done with an interface before the flight deck signals ‘initial approach’.

(more…)

Quick and Powerful Database with OpenOffice.org and Postgres



Connect
About the Bloggers
  • Ed Boyajian
    Ed Boyajian
    President and Chief Executive Officer
  • Jim Mlodgenski
    Jim Mlodgenski
    Chief Architect

  • Larry Alston
    Larry Alston
    VP, Marketing and Product Management
  • Bruce Momjian
    Bruce Momjian
    Senior Database Architect
  • Scott Mead
    Scott Mead
    Principal Systems Engineer
  • Ingrid Catlin
    Ingrid Catlin
    Online Marketing Manager
Search