Magic words:
psql -U postgresSome interesting flags (to see all, use -h or --help depending on your psql version):
-E: will describe the underlaying queries of the \ commands (cool for learning!)-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
When hosting our web applications, we often have one public IP
address (i.e., an IP address visible to the outside world)
using which we want to host multiple web apps. For example, one
may wants to host three different web apps respectively for
example1.com, example2.com, and example1.com/images on
the same machine using a single IP address.
How can we do that? Well, the good news is Internet browsers
| #!/bin/bash | |
| # Script to install a ubuntu trusty tahr 14.04 LTS template on xcp or | |
| # Citrix (TM) Xenserver 5.6 and above. | |
| # Copyright (C) 2014 Arne-Kristian Hingst - All Rights Reserved | |
| # Permission to copy and modify is granted under the eupl license | |
| # http://ec.europa.eu/idabc/servlets/Docbb6d.pdf?id=31979 | |
| # Last revised 04/20/2014 | |
| # | |
| # Add your favourite mirror here |
| # Find the IAM username belonging to the TARGET_ACCESS_KEY | |
| # Useful for finding IAM user corresponding to a compromised AWS credential | |
| # Requirements: | |
| # | |
| # Environmental variables: | |
| # AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY | |
| # python: | |
| # boto |
| (defun source (filename) | |
| "Update environment variables from a shell source file." | |
| (interactive "fSource file: ") | |
| (message "Sourcing environment from `%s'..." filename) | |
| (with-temp-buffer | |
| (shell-command (format "diff -u <(true; export) <(source %s; export)" filename) '(4)) | |
| (let ((envvar-re "declare -x \\([^=]+\\)=\\(.*\\)$")) |
| // kills long running ops in MongoDB (taking seconds as an arg to define "long") | |
| // attempts to be a bit safer than killing all by excluding replication related operations | |
| // and only targeting queries as opposed to commands etc. | |
| killLongRunningOps = function(maxSecsRunning) { | |
| currOp = db.currentOp(); | |
| for (oper in currOp.inprog) { | |
| op = currOp.inprog[oper-0]; | |
| if (op.secs_running > maxSecsRunning && op.op == "query" && !op.ns.startsWith("local")) { | |
| print("Killing opId: " + op.opid |
| type ( | |
| // BuoyCondition contains information for an individual station. | |
| BuoyCondition struct { | |
| WindSpeed float64 `bson:"wind_speed_milehour"` | |
| WindDirection int `bson:"wind_direction_degnorth"` | |
| WindGust float64 `bson:"gust_wind_speed_milehour"` | |
| } | |
| // BuoyLocation contains the buoy's location. | |
| BuoyLocation struct { |
| { | |
| "handlers": { | |
| "victorops": { | |
| "type": "pipe", | |
| "command": "/etc/sensu/handlers/victorops.rb" | |
| } | |
| }, | |
| "checks": { | |
| "tmp_check": { | |
| "description": "check that /tmp exists ", |
| ## credit: http://fabian-affolter.ch/blog/the-lineinfile-module-of-ansible/ | |
| --- | |
| - hosts: alpine_install | |
| user: root | |
| tasks: | |
| # - name: create a complete empty file | |
| # command: /usr/bin/touch /test/test.conf | |
| - name: create a new file with lineinfile |