Moving from Oracle to PostgreSQL, what (ideally free/OSS) software/tools can be found that replace Oracle Enterprise Manager? I am conscious of pgAdmin, in addition to some tools bundled up into EnterpriseDB's Postgres Plus AS, but am searching for more context along with a better summary of the PostgreSQL ecosystem.
Particularly I am thinking about tools to assist:
- Alert db managers to issues with both configuration and gratifaction
- Monitoring of overall system performance
- General performance tuning
- Hinting support (my understanding is the fact that PostgreSQL typically frowns on hinting)
- Disk management (ease in growth)
- Backup/restore beyond pg_dump and pg_restore
Any ideas? This appears like something plenty of people might have been through before.
Postgres includes excellent command-line tools, and they are the main focus from the core developer team. Personally, i leverage individuals via custom site-specific scripts for db admin, upgrade, replication. For monitoring I personally use nagios to script psql to question vitals.
Nevertheless, you will find another choices on the GUI-side beyond pgAdmin:
I do not think these have each of the features you listed, but they could be a great jumping off point. I doubt you'll find a wide open source tool that actually competes mind-to-mind with Oracle Enterprise Manager. Around the commercial-side, you will find also additional options:
This wiki page also offers links with other postgres tools:
As being a CLI-zealot myself I am unable to given any sort of recommendations but hopefully this really is useful.
I believe the very best site to find software that matches your need could be PgFoundry: http://pgfoundry.org/
I do not think there's an application that matches all of your needs but you may can mix some tools to obtain what you would like.
I've been with a couple free gui tools but none of them from it compares with Navicat PostgreSQL GUI. I believe it is the Cat Pajamas!
they have a totally free version now, http://www.navicat.com.