over 2 years ago

Protgresql

$ cp /etc/apache2/conf.d/phppgadmin /etc/apache2/conf-enabled/phppgadmin.conf

先建立$USER

$ sudo -u postgres createuser --superuser $USER
$ sudo -u postgres psql
postgres=# \password $USER
$ sudo -u postgres createdb $USER
$ sudo -u postgres dropdb  [option...] dbname

DUMP + UP:

$ pg_dump dbname > outfile
$ pg_dumpall > outfile

Dump Only Schema :

$ pg_dump -s > outfile

SSH

https://blog.longwin.com.tw/2008/10/security-debian-ubuntu-linux-deny-root-login-2008/
http://www.study-area.org/tips/ssh_tips.htm

圖片伺服器

弄了一個上傳專用的接口on Github

CDN

可以把網站的static file放在這

RawGit

← [筆記] ROR的第一次 淺談衛宮切嗣 →
 
comments powered by Disqus