I rarely post in this group, but felt input would be important to chime in here from a security aspect.
One of the primary challenges I've seen in the past with migrating to PostgreSQL from Oracle is implementing DISA STIG compliance. This may or may not be a requirement in your environment.
While there is an Oracle STIG available, there is currently no PostgreSQL STIG - so you will need to engineer much of the required settings/etc. using the Generic Database STIG located at http://iase.disa.mil/stigs/app_security/database/general.html
Fortunately, because PostgreSQL is "secure by default" many of the needed settings are already in place by default. However, you still need documentation to prove this to an auditor.
I am currently working for the Government and there is a huge push to move our Oracle databases to a FOSS database solution. Right now, PostgreSQL is high on the list.
What we need is a meeting/training session with the main contributors to Postgres to help facilitate solutions of some of the Oracle functionality to Postgres. This may be an opportunity to gather Government requirements for additional Postgres releases. The meeting would be in the Columbia area.
Some of our needs: Package structure similar to Oracle Parallel queries Multi Master Replication
Some of the names I've seen Tom Lane Robert Haas Greg Smith Simon Riggs
Please let me know if a meeting is possible. There is another in-house meeting April 17th where I would like to pass on contact information or needs from the contributors.
