TL;DR
Install Postgres 9.6, and then:
sudo pg_dropcluster 9.6 main --stop
sudo pg_upgradecluster 9.5 main
sudo pg_dropcluster 9.5 main
country_abbreviations = [ | |
%{name: "Afghanistan", alpha_2_code: "AF", alpha_3_code: "AFG", continent: "asia"}, | |
%{name: "Aland Islands", alpha_2_code: "AX", alpha_3_code: "ALA", continent: "europe"}, | |
%{name: "Albania", alpha_2_code: "AL", alpha_3_code: "ALB", continent: "europe"}, | |
%{name: "Algeria", alpha_2_code: "DZ", alpha_3_code: "DZA", continent: "africa"}, | |
%{name: "American Samoa", alpha_2_code: "AS", alpha_3_code: "ASM", continent: "australia_and_oceania"}, | |
%{name: "Andorra", alpha_2_code: "AD", alpha_3_code: "AND", continent: "europe"}, | |
%{name: "Angola", alpha_2_code: "AO", alpha_3_code: "AGO", continent: "africa"}, | |
%{name: "Anguilla", alpha_2_code: "AI", alpha_3_code: "AIA", continent: "north_america"}, | |
%{name: "Antarctica", alpha_2_code: "AQ", alpha_3_code: "ATA", continent: "antartica"}, |
currency_codes = [ | |
"AED", | |
"AFN", | |
"ALL", | |
"AMD", | |
"ARS", | |
"AUD", | |
"AZN", | |
"BAM", | |
"BDT", |
# List users (with permissions) | |
\du | |
# List databases | |
\l | |
# List schemas, with privileges | |
\dn+ | |
# List table privileges |
############# | |
# Processes # | |
############# | |
# Finding a running process | |
ps aux | grep <processname> | |
pgrep <processname> | |
# Killing processes | |
# |
country_codes = [ | |
%{ iso_3166_1: "AF", name: "Afghanistan" }, | |
%{ iso_3166_1: "AX", name: "Aland Islands" }, | |
%{ iso_3166_1: "AL", name: "Albania" }, | |
%{ iso_3166_1: "DZ", name: "Algeria" }, | |
%{ iso_3166_1: "AS", name: "American Samoa" }, | |
%{ iso_3166_1: "AD", name: "Andorra" }, | |
%{ iso_3166_1: "AO", name: "Angola" }, | |
%{ iso_3166_1: "AI", name: "Anguilla" }, | |
%{ iso_3166_1: "AQ", name: "Antarctica" }, |
iso_codes = [ | |
%{ iso_639_1: "ab", name: "Abkhazian" }, | |
%{ iso_639_1: "aa", name: "Afar" }, | |
%{ iso_639_1: "af", name: "Afrikaans" }, | |
%{ iso_639_1: "ak", name: "Akan" }, | |
%{ iso_639_1: "sq", name: "Albanian" }, | |
%{ iso_639_1: "am", name: "Amharic" }, | |
%{ iso_639_1: "ar", name: "Arabic" }, | |
%{ iso_639_1: "an", name: "Aragonese" }, | |
%{ iso_639_1: "hy", name: "Armenian" }, |
TL;DR
Install Postgres 9.6, and then:
sudo pg_dropcluster 9.6 main --stop
sudo pg_upgradecluster 9.5 main
sudo pg_dropcluster 9.5 main
# | |
# Would this be useful to Phoenix? | |
# | |
# In controllers, it'd be nice to be able to refer to status codes as atoms instead of integers. | |
# | |
defmodule Phoenix.Controller.StatusCodes do | |
@http_status_codes %{ |
#Most Popular Screen Resolutions
##Apple
Resolution | Device |
---|---|
320×480 | iPhone 3GS |
640×960 | iPhone 4S |
1024×768 | iPad 1/2/Mini |
1024×768+ | Desktops/Laptops |
Log in as root
ssh root@123.45.67.890
Change root password
passwd
Create new user