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.
Installing Postgres Plus Standard ServerAuthor Archive
How to Install Postgres Binaries (in One Click)
Tuesday, November 3rd, 2009 by Scott MeadIn 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!
How to Install Postgres Binaries (in One Click)Scaling Postgres Plus Advanced Server in the Cloud
Friday, October 23rd, 2009 by Scott MeadThe 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.
Scaling Postgres Plus Advanced Server in the CloudHow to Monitor a Postgres Warm Standby
Tuesday, September 22nd, 2009 by Scott MeadWarm 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 …
How to Monitor a Postgres Warm StandbyQuick and Powerful Database with OpenOffice.org and Postgres
Sunday, July 26th, 2009 by Scott MeadUnless 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:
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’.
Quick and Powerful Database with OpenOffice.org and Postgres
