[For Mac users] After updating to Mac OS #Catalina a dialog will appear on the first startup. To continue using Gyazo please press "Open System Preferences", select "Image Recording" from "Security and Privacy", and check Gyazo and Gyazo GIF.https://t.co/VMKPPgLoaDpic.twitter.com/WHfaI3BBiq
mkdir-p ~/.config/nvim
cd ~/.config/nvim
vi init.vim
~/.config/nvim/init.vim
set fenc=utf-8setnoswapfileset autoread
set showcmd
setnumberset cursorline
set cursorcolumn
set virtualedit=onemore
set smartindent
set showmatch
set statusline=2set wildmode=list:longest
nnoremap j gj
nnoremap k gk
set list listchars=tab:\▸\-set expandtab
set tabstop=2set shiftwidth=2set ignorecase
set smartcase
set incsearch
set wrapscan
set hlsearch
nmap <Esc><Esc>:nohlsearch<CR><Esc>if &compatible
set nocompatible
endif" Add the dein installation directory into runtimepathset runtimepath+=~/.cache/dein/repos/github.com/Shougo/dein.vimif dein#load_state('~/.cache/dein')call dein#begin('~/.cache/dein')call dein#add('~/.cache/dein/repos/github.com/Shougo/dein.vim')call dein#add('Shougo/deoplete.nvim')if!has('nvim')call dein#add('roxma/nvim-yarp')call dein#add('roxma/vim-hug-neovim-rpc')endif" tomlcall dein#load_toml('~/.config/nvim/dein.toml',{'lazy':0})call dein#load_toml('~/.config/nvim/dein_lazy.toml',{'lazy':0})" auto installif dein#check_install()call dein#install()endifcall dein#end()call dein#save_state()endiffiletype plugin indent on
syntax enable
colorscheme molokai
// psqluser というロール名に postgres というパスワードを設定
psqldb=> alter role psqluser with password 'postgres';
ALTER ROLE
//ロール名の一覧を確認
paqldb=> \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+-----------
k | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
psqluser | | {}
paqluserにはなんの権限もない状態なので権限を付与する
psqldb=> ALTER ROLE psqluser WITH CREATEDB;
ERROR: permission denied
むむむ、エラーだ
一度kというユーザーとしてpsqldbに接続
$ psql -U k psqldb
psqldb=# ALTER ROLE psqluser WITH createdb;
ALTER ROLE
psqldb=# ALTER ROLE psqluser WITH createrole;
ALTER ROLE
psqldb=# ALTER ROLE psqluser WITH Superuser;
ALTER ROLE
psqldb=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+------------
k | Superuser, Create role, Create DB, Replication, Bypass RLS | {psqluser}
psqluser | Superuser, Create role, Create DB | {}
psqluser に無事権限を付与できた
よくあるエラー
k$ postgres -D /usr/local/var/postgres
2019-10-22 23:04:38.695 JST [14260] FATAL: lock file "postmaster.pid" already exists
2019-10-22 23:04:38.695 JST [14260] HINT: Is another postmaster (PID 13895) running in data directory "/usr/local/var/postgres"?
2019-10-22 23:04:57.924 JST [14265] LOG: listening on IPv6 address "::1", port 5432
2019-10-22 23:04:57.924 JST [14265] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-10-22 23:04:57.926 JST [14265] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
2019-10-22 23:04:57.950 JST [14266] LOG: database system was interrupted; last known up at 2019-10-22 22:49:54 JST
2019-10-22 23:04:58.084 JST [14266] LOG: database system was not properly shut down; automatic recovery in progress
2019-10-22 23:04:58.087 JST [14266] LOG: redo starts at 0/167D3D0
2019-10-22 23:04:58.087 JST [14266] LOG: invalid record length at 0/167D4B0: wanted 24, got 0
2019-10-22 23:04:58.087 JST [14266] LOG: redo done at 0/167D478
2019-10-22 23:04:58.100 JST [14265] LOG: database system is ready to accept connections
// psqluser というロール名に postgres というパスワードを設定
psqldb=> alter role psqluser with password 'postgres';
ALTER ROLE
//ロール名の一覧を確認
paqldb=> \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+-----------
k | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
psqluser | | {}
paqluserにはなんの権限もない状態なので権限を付与する
psqldb=> ALTER ROLE psqluser WITH CREATEDB;
ERROR: permission denied
むむむ、エラーだ
一度kというユーザーとしてpsqldbに接続
$ psql -U k psqldb
psqldb=# ALTER ROLE psqluser WITH createdb;
ALTER ROLE
psqldb=# ALTER ROLE psqluser WITH createrole;
ALTER ROLE
psqldb=# ALTER ROLE psqluser WITH Superuser;
ALTER ROLE
psqldb=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+------------
k | Superuser, Create role, Create DB, Replication, Bypass RLS | {psqluser}
psqluser | Superuser, Create role, Create DB | {}
psqluser に無事権限を付与できた
よくあるエラー
k$ postgres -D /usr/local/var/postgres
2019-10-22 23:04:38.695 JST [14260] FATAL: lock file "postmaster.pid" already exists
2019-10-22 23:04:38.695 JST [14260] HINT: Is another postmaster (PID 13895) running in data directory "/usr/local/var/postgres"?
2019-10-22 23:04:57.924 JST [14265] LOG: listening on IPv6 address "::1", port 5432
2019-10-22 23:04:57.924 JST [14265] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-10-22 23:04:57.926 JST [14265] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
2019-10-22 23:04:57.950 JST [14266] LOG: database system was interrupted; last known up at 2019-10-22 22:49:54 JST
2019-10-22 23:04:58.084 JST [14266] LOG: database system was not properly shut down; automatic recovery in progress
2019-10-22 23:04:58.087 JST [14266] LOG: redo starts at 0/167D3D0
2019-10-22 23:04:58.087 JST [14266] LOG: invalid record length at 0/167D4B0: wanted 24, got 0
2019-10-22 23:04:58.087 JST [14266] LOG: redo done at 0/167D478
2019-10-22 23:04:58.100 JST [14265] LOG: database system is ready to accept connections
