tisa.g0v.tw development
編輯歷史
| 時間 | 作者 | 版本 |
|---|---|---|
| 2017-07-07 16:35 – 16:35 | r0 – r1 | |
顯示 diff-
+ tisa.g0v.tw development
+ This board contains sensitive information and was shared to "invitees only".
+ Insensitive information should be going to 服貿協議相關 g0v 專案
+ *Production
+ SSH access
+ Transfer your `~/.ssh/id_rsa.pub` to authorized owners for ssh access without password.
+ *$ ssh tisa@<ip>
+ If you don't have `id_rsa.pub`, run
+ *$ ssh-keygen
+ Then you will have it in `~/.ssh/`
+ Machine List
+ For your conveniences to access rapidly, put this machines into your `~/.ssh/config` as following format.
+ *Host tisa
+ * HostName 162.243.145.68
+ * User tisa
+ * Port 22
+ *tisa
+ *Function: Reverse Proxy by Nginx, Postgresql 9.3 (Postgis Extension), App
+ *IP: `162.243.145.68`
+ *tisa-app1 (shut down)
+ *Function: App
+ *IP: `107.170.210.212`
+ *tisa-app2 (shut down)
+ *Function: App
+ *IP: `107.170.209.101`
+ *tisa-db1 (shut down)
+ *Function: Database by Postgresql 9.3 (Postgis Extension)
+ *IP: `107.170.209.102`
+ *Running App as well
+ Deployment
+ All `/tisa-app\\d+/` machines have a clone of codebase at `~/tisa-map`. Currently we have no capistrano script. Just run
+ *$ git pull
+ And restart unicorn server in `screen` session.
+ Database
+ *setup
+ *$ createuser tisa --superuser --encrypted --pwprompt
+ *$ createdb tisa
+ *$ sequel config/database.yml -m migrations
+ *connection
+ To run Sequel console, put following content in `config/database.yml`
+ *production:
+ * :adapter: postgres
+ * :host: 162.243.145.68
+ * :database: tisa
+ * :username: tisa
+ * :password: tisamap
+ * :encoding: utf8
+ * :pool: 5
+ And run
+ *$ sequel config/database.yml
+ *backup
+ *$ pg_dump --blobs --verbose --no-owner --format tar --encoding utf8 --file tisa-yyyy-mm-dd.tar tisa
+ Some recent backups from the production environment
+ *http://140.112.20.144/tisa-2014-04-06.tar
+ *http://140.112.20.144/tisa-2014-04-10.tar
+ *http://140.112.20.144/tisa-2014-04-19.tar
+ *restore
+ *$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U tisa -d tisa --format tar tisa-yyyy-mm-dd.tar
+ *Development
+ postgresql array column
+ http://sequel.jeremyevans.net/rdoc-plugins/files/lib/sequel/extensions/pg_array_rb.html
+ http://www.postgresql.org/docs/9.3/static/functions-array.html
+ postgresql json column
+ http://sequel.jeremyevans.net/rdoc-plugins/files/lib/sequel/extensions/pg_json_rb.html
+ http://www.postgresql.org/docs/9.3/static/functions-json.html
+ 代碼對照表 與 服務貿易特定承諾表 對照數字(紅字, 57 個)
+ https://www.dropbox.com/sh/xh488y46hgxjy6b/LFIfMNhQ_M
+ *Schema
+ Company
+ *
+ Tisa
+ *
+ CPC
+ *
+ Group
+ *
+ Category
+ Standard
+ *
+ *Contributors
+ nchild xchild@gmail.com
+ Shelling Ford navyblueshellingford@gmail.com
+ howard chi chilijung@gmail.com
+ Johnson Liang johnsonliang7@gmail.com
+ Shenk Wang shenkyw@gmail.com
+ ipa chiu ipawei@gmail.com
+ Lucien Lee lkiral7903@gmail.com
+ WeiHung wayne930242@gmail.com
|
||