wikiti

# List databases
sudo su postgres
psql
\list

# Create a compressed backup
sudo su postgres
pg_dump -Fc <database_name> > <file>

# Example

ricjcosme

DUMP
// pod-name         name of the postgres pod
// postgres-user    database user that is able to access the database
// database-name    name of the database
kubectl exec [pod-name] -- bash -c "pg_dump -U [postgres-user] [database-name]" > database.sql

RESTORE
// pod-name         name of the postgres pod
// postgres-user    database user that is able to access the database
// database-name    name of the database

kurobeats

#!/bin/bash

# WARNING: to use "--binary-images hdd", see this bug: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=773833
# WARNING: to get persistence encryption working, apply this fix: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=767195

# Italian locale & keyboard, default boot with luks encrypted persistence
# lb config --distribution jessie --debian-installer live --binary-images iso-hybrid --archive-areas "main contrib non-free" --bootappend-live "boot=live persistence persistence-encryption=luks locales=it_IT.UTF-8 keyboard-layouts=it username=utente hostname=D8"
# lb config --distribution jessie --debian-installer live --binary-images iso-hybrid --archive-areas "main contrib non-free" --bootappend-live "boot=live persistence persistence-encryption=luks keyboard-layouts=it username=user hostname=D8"
 
# Default locale & norwegian keyboard, pxe boot

brock

# This is just a cheat sheet:

# On production
sudo -u postgres pg_dump database | gzip -9 > database.sql.gz

# On local
scp -C production:~/database.sql.gz
dropdb database && createdb database
gunzip < database.sql.gz | psql database

learncodeacademy

##Setup your server (this would ideally be done with automated provisioning)

• add a deploy user with password-less ssh see this gist
• install forever npm install -g forever

##Install flightplan

• npm install -g flightplan
• in your project folder npm install flightplan --save-dev
• create a flightplan.js file

dylanvalade

// Register keyboard events
$(document).keydown(function(e) {
	if (e.keyCode === 37) {
	   // Previous
	   $(".carousel-control.left").click();
	   return false;
	}
	if (e.keyCode === 39) {
	   // Next
	   $(".carousel-control.right").click();

jlazanowski

<script>
  $(document).ready(function() {  
          //add your other targets here
       $("#myCarousel, #myOtherCarousel").swiperight(function() {  
          $(this).carousel('prev');  
          });  
//add your other targets here
       $("#myCarousel, #myOtherCarousel").swipeleft(function() {  
          $(this).carousel('next');  
     });  

crtr0

// set-up a connection between the client and the server
var socket = io.connect();

// let's assume that the client page, once rendered, knows what room it wants to join
var room = "abc123";

socket.on('connect', function() {
   // Connected, let's sign-up for to receive messages for this room
   socket.emit('room', room);
});