• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • PostgreSQL Database On Power Systems-IBM i? Why Not?

    July 11, 2011 Timothy Prickett Morgan

    The profile of the open source PostgreSQL database has been rising in recent months, and you can run it on an IBM i platform if you have a Web application that requires that database.

    PostgreSQL got an immediate boost the minute that Oracle closed its $7.4 billion acquisition of Sun Microsystems in January 2010. That’s because Sun owned the popular MySQL database at that point, and companies that did not want to be beholden to Oracle, which owns a slew of databases after many acquisitions and much internal databases. A heavily modified PostgreSQL database is embedded in IBM‘s Netezza data warehouse appliances, which are goosed by field programmable gate arrays (FPGAs) to extract and chew data, and the Oracle compatibility layer in DB2 V9.5 and V9.7 for Linux, Unix, and Windows operating systems comes from EnterpriseDB, the commercial entity that offers support for PostgreSQL and contributes heavily to the project. And thanks to the legal tiff between Hewlett-Packard and Oracle over Oracle ceasing development of its database, middleware, and application software on future Itanium processors, PostgreSQL, which just got formal support for HP-UX Unix last week, is being positioned as an Oracle alternative by HP and EnterpriseDB. And the fact that Oracle has yanked support for MySQL on IBM i, which has irked a number of i shops, might see PostgreSQL slide in as a supported open source alternative if EnterpriseDB gets enough interest.

    In any event, Ryan Watkins of IBM has posted directions for installing the open source PostgreSQL database on the Young i Professionals (YiPs) Wiki, which you can read here. You will need to have the PASE for i AIX runtime environment (Option 33 for the i/OS and IBM i operating system) as well as IBM’s XL C/C++ compiler for AIX and the RPM Package Manager, which will run inside PASE. PosgreSQL will obviously run inside PASE. You could also run it on AIX within a logical partition. It is not clear what replication tools are available, but I know that that EnterpriseDB has a replicator called xDB that can suck data out of Oracle or SQL Server databases and pump it into PostgreSQL databases. You might need IBM’s InfoSphere Replication Server to do the trick.

    Have fun.

    RELATED STORIES

    IBM and VCs Invest in EnterpriseDB

    Sun Casts a $1 Billion Net to Catch MySQL

    Sun Picks EnterpriseDB to Backup PostgreSQL Support in Solaris

    PostgreSQL Database Now Runs Natively on Windows



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    ARCAD Software

    [Webinar] Creating test data, easily and quickly!

    June 22 at 12 p.m. EST

    Software testing needs realistic, consistent data available on demand, where and when needed. However, providing testers with a copy of the entire production database is costly both in time and disk space.

    In this webinar, we’ll demonstrate how to:

    • Easily create coherent test datasets, small enough for rapid test cycles, but large enough to accurately reflect the variety of production data
    • Anonymize the datasets to protect any PII
    • Inject into test environments in a snap

    Join us on this webinar with Alan Ashley, solution architect, and learn how to subset your data.

    Register now!

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Maidenform Picks CYBRA for RFID Silvon Re-Emerges with Update to Stratum BI

    Leave a Reply Cancel reply

Volume 20, Number 24 -- July 11, 2011
THIS ISSUE SPONSORED BY:

PowerTech
New Generation Software
Cosyn
Linoma Software
WorksRight Software

Table of Contents

  • Business Is IBM’s Middle Name
  • Lennox Takes CMO Job as Zend Plans for Growth
  • Gartner, IDC Boost IT Spending Outlooks For 2011
  • As I See It: An Icy Place Apart
  • iManifest EMEA Plans Webcast, IBM i Collateral
  • Reader Feedback on Building a Legacy
  • IBM Revives BladeCenter Chassis Giveaway
  • PostgreSQL Database On Power Systems-IBM i? Why Not?
  • Public Clouds Like Cheap Iron, Private Clouds Like the Expensive Stuff
  • Lawson Stockholders Approve Infor Merger. What’s Next?

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • IBM i Delivers Sizable Benefits, Forrester Consulting Reports
  • SBOMs Will Come to IBM i, Eventually
  • IBM i Backup Provider Storagepipe Snapped Up By Thrive
  • Four Hundred Monitor, June 7
  • IBM i PTF Guide, Volume 25, Number 23
  • Power10 Boosts NVM-Express Flash Performance
  • Fortra Completes Postmortem Of GoAnywhere Vulnerability
  • Guru: Binding Directory Entries
  • How Does Your Infrastructure Spending Stack Up To The World?
  • IBM i PTF Guide, Volume 25, Number 22

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle