falcn

#  ---------------------------------------------------------------------------
#
#  Description:  This file holds all my BASH configurations and aliases
#
#  Sections:
#  1.   Environment Configuration
#  2.   Make Terminal Better (remapping defaults and adding functionality)
#  3.   File and Folder Management
#  4.   Searching
#  5.   Process Management

jmeridth

change to postgres user and open psql prompt

sudo -u postgres psql postgres

list databases

postgres=# \l

list roles

stephen-puiszis

# Elasticsearch Cheatsheet - an overview of commonly used Elasticsearch API commands

# cat paths
/_cat/allocation
/_cat/shards
/_cat/shards/{index}
/_cat/master
/_cat/nodes
/_cat/indices
/_cat/indices/{index}

LexxFedoroff

input {
        file {
                path => "/var/log/cassandra/system.log"
                #start_position => "beginning"
        }
        #stdin { }
}

filter {
        multiline {

syafiqfaiz

1. Change your database RDS instance security group to allow your machine to access it.
   • Add your ip to the security group to acces the instance via Postgres.
2. Make a copy of the database using pg_dump
   • $ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>
   • you will be asked for postgressql password.
   • a dump file(.sql) will be created
3. Restore that dump file to your local database.
   • but you might need to drop the database and create it first
   • $ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>

• the database is restored

ibspoof

filter {

    if [type] == "cassandralog" {
        grok {
            break_on_match => true
            match => {
                "message" => [
                    "%{CASS_COMPACTION_LARGE_KEY}",
                    "%{CASS_SLAB_POOL_CLEANER_1}",
                    "%{CASS_SLAB_POOL_CLEANER_2}",

tzach

#!/bin/bash -e                                                                                                                                                                           

mkdir report
rpm -qa > ./report/rpm.txt
journalctl -b > ./report/journalctl.txt
df -k > ./report/df.txt
netstat > ./report/netstat.txt

sar -P ALL > ./report/sar.txt
iostat -d 1 10  > ./report/iostat.txt

JonCole

Debugging Redis Keyspace Misses

Simply put, a keyspace "MISS" means some piece of data you tried to retrieve from Redis was not there. This usually means that one of the following things happened:

1. The key expired
2. They key was renamed
3. The key was deleted
4. The key was evicted due to memory pressure
5. The entire database was flushed
6. The key was never actually inserted

sergeyklay

Sed Cheat Sheet

Sed command line options

sed [options] sed-command [input-file]

Option	Description	Example

gitschaub

# If using the RTP cluster, replace:
#   <couchbase-ip>:8091  ->  couchbase-ivpp.apps.vmware.openshift.wwva.ciscolabs.com
#   <couchbase-ip>:8092  ->  couchbase-xdcr-ivpp.apps.vmware.openshift.wwva.ciscolabs.com

# To see all of the buckets on the server.
curl -u Administrator:password -XGET http://<couchbase-ip>:8091/pools/default/buckets

# To delete an existing bucket.
curl -u Administrator:password -XDELETE http://<couchbase-ip>:8091/pools/default/buckets/<bucket-name>