New charm postgresql-psql
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Juju Charms Collection |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
I have a new charm at lp:~stub/charms/precise/postgresql-psql/trunk
# Overview
This charm provides shell access to PostgreSQL services via the standard
psql tool.
# Usage
To setup a test environment::
juju bootstrap
juju deploy postgresql
juju deploy postgresql-psql psql
juju add-relationship postgresql:db psql:db
juju add-relationship postgresql:db-admin psql:db-admin
On the psql unit, wrappers to psql have been installed to provide easy access:
juju ssh 2
Standard 'db' relations have a wrapper installed connecting to the
defined database on each individual PostgreSQL unit::
% psql-db-
psql (9.1.9)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.
psql=> \q
Administrative 'db-admin' relations have a wrapper installed that can be
used to connect to any database on each individual PostgreSQL unit::
% psql-db-
psql (9.1.9)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.
postgres=# \q
The default database name for 'db' relations may be overridden::
juju set psql database=foo2
juju ssh 2
% psql-db-
psql (9.1.9)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.
foo2=> \q
Related branches
- Kapil Thangavelu (community): Approve
-
Diff: 1261 lines (+994/-171)5 files modifiedcharm-helpers.yaml (+4/-0)
hooks/charmhelpers/core/hookenv.py (+339/-0)
hooks/charmhelpers/core/host.py (+272/-0)
hooks/hooks.py (+36/-94)
icon.svg (+343/-77)
Changed in charms: | |
status: | New → Incomplete |
Reviewing this now.
-Juan