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 [email protected]
Change root password
passwd
Create new user