Comment 5 for bug 1359837

The install hook failure in all likely hood nothing to do with PostgreSQL itself, but something else like a stuck apt cache lock. Nothing except the ~/.juju/local/log/unit-postgresql-0.log will help diagnose the hook failure.