Managing overview on amazon

Getting a database shell

• overview-manage ssh to log in to the manage instance
• grep database-url /opt/overview/config/manage/secrets.yml to find the URL of the Postgres database
• Ctrl-D to log out
• overview-manage ssh production web to log in to a server that isn't separated from the database by a firewall
• sudo apt-get install postgresql-client-9.1 if it isn't already installed.
• psql -h [HOST] --user [USERNAME] [DATABASE] and enter the password.