launchpad isn't letting me attach the file so I'm including the last chunk of lines here:

2014-08-22 19:50:21 DEBUG juju-log Running 'getconf PAGE_SIZE'
2014-08-22 19:50:21 INFO juju-log Writing file /etc/sysctl.d/50-postgresql.conf root:root 600
2014-08-22 19:50:21 DEBUG juju-log Running 'sysctl -p /etc/sysctl.d/50-postgresql.conf'
2014-08-22 19:50:21 INFO install sysctl: permission denied on key 'kernel.sem'
2014-08-22 19:50:21 INFO juju-log Writing file /etc/postgresql/9.3/main/postgresql.conf postgres:postgres 600
2014-08-22 19:50:21 DEBUG juju-log Running ['pgtune', '-i', u'/etc/postgresql/9.3/main/postgresql.conf', '-o', '/tmp/tmpYKhaHe', '-T', u'mixed', '-c', '100']
2014-08-22 19:50:21 INFO juju-log Writing file /etc/postgresql/9.3/main/postgresql.conf postgres:postgres 600
2014-08-22 19:50:21 INFO juju-log Writing file /etc/postgresql/9.3/main/pg_ident.conf postgres:postgres 600
2014-08-22 19:50:21 INFO juju-log []
2014-08-22 19:50:21 INFO juju-log Writing file /etc/postgresql/9.3/main/pg_hba.conf postgres:postgres 600
2014-08-22 19:50:21 DEBUG juju-log PostgreSQL is not running
2014-08-22 19:50:21 DEBUG juju-log PostgreSQL is not running
2014-08-22 19:50:21 DEBUG juju-log Running ['pg_ctlcluster', '9.3', u'main', 'start']
2014-08-22 19:50:24 INFO juju-log PostgreSQL started
2014-08-22 19:50:24 INFO install error: cannot open ports 5432-5432/tcp for unit "postgresql/0": cannot open ports 5432-5432/tcp on machine 1 due to conflict
2014-08-22 19:50:24 INFO install 4096
2014-08-22 19:50:24 INFO install
2014-08-22 19:50:24 INFO install kernel.shmall = 4083713
2014-08-22 19:50:24 INFO install
2014-08-22 19:50:24 INFO install kernel.shmmax = 16726885376
2014-08-22 19:50:24 INFO install
2014-08-22 19:50:24 INFO install Traceback (most recent call last):
2014-08-22 19:50:24 INFO install   File "/var/lib/juju/agents/unit-postgresql-0/charm/hooks/install", line 2349, in <module>
2014-08-22 19:50:24 INFO install     hooks.execute(sys.argv)
2014-08-22 19:50:24 INFO install   File "/var/lib/juju/agents/unit-postgresql-0/charm/hooks/charmhelpers/core/hookenv.py", line 478, in execute
2014-08-22 19:50:24 INFO install     self._hooks[hook_name]()
2014-08-22 19:50:24 INFO install   File "/var/lib/juju/agents/unit-postgresql-0/charm/hooks/install", line 1025, in install
2014-08-22 19:50:24 INFO install     config_changed(force_restart=True)
2014-08-22 19:50:24 INFO install   File "/var/lib/juju/agents/unit-postgresql-0/charm/hooks/install", line 941, in config_changed
2014-08-22 19:50:24 INFO install     update_service_port()
2014-08-22 19:50:24 INFO install   File "/var/lib/juju/agents/unit-postgresql-0/charm/hooks/install", line 659, in update_service_port
2014-08-22 19:50:24 INFO install     hookenv.open_port(new_port)
2014-08-22 19:50:24 INFO install   File "/var/lib/juju/agents/unit-postgresql-0/charm/hooks/charmhelpers/core/hookenv.py", line 415, in open_port
2014-08-22 19:50:24 INFO install     subprocess.check_call(_args)
2014-08-22 19:50:24 INFO install   File "/usr/lib/python2.7/subprocess.py", line 540, in check_call
2014-08-22 19:50:24 INFO install     raise CalledProcessError(retcode, cmd)
2014-08-22 19:50:24 INFO install subprocess.CalledProcessError: Command '['open-port', '5432/TCP']' returned non-zero exit status 1
2014-08-22 19:50:24 ERROR juju.worker.uniter uniter.go:563 hook failed: exit status 1