$ sudo install -o redis -g redis -d /var/lib/redis2
$ sudo cp -p /etc/redis/redis.conf /etc/redis/redis2.conf
#!/usr/bin/env bash | |
# This script installs PhantomJS on your Debian/Ubuntu System | |
# | |
# Taken from https://gist.github.com/julionc/7476620#gistcomment-2030572 and changed the download directory | |
# | |
# This script must be run as root: | |
# sudo sh install_phantomjs.sh | |
if [[ $EUID -ne 0 ]]; then | |
echo "This script must be run as root" 1>&2 |
#!/bin/bash | |
### USAGE | |
### | |
### ./ElasticSearch.sh will install Elasticsearch 2.x | |
### | |
### CLI options Contributed by @janpieper | |
### Check http://www.elasticsearch.org/download/ for latest version of ElasticSearch | |
### ElasticSearch version |
DROP TABLE IF EXISTS time_dimension; | |
CREATE TABLE time_dimension ( | |
id INTEGER PRIMARY KEY, -- year*10000+month*100+day | |
db_date DATE NOT NULL, | |
year INTEGER NOT NULL, | |
month INTEGER NOT NULL, -- 1 to 12 | |
day INTEGER NOT NULL, -- 1 to 31 | |
quarter INTEGER NOT NULL, -- 1 to 4 | |
week INTEGER NOT NULL, -- 1 to 52/53 | |
day_name VARCHAR(9) NOT NULL, -- 'Monday', 'Tuesday'... |