Padres 之database

决定先从现成的Padres学起， 一点一点肢解Padres 代码，鉴于自己还无法编写大型程序，只能边学边抄。

error 

git hub error

(non-fast-forward)

error: failed to push some refs to **

hint: Updates were rejected because a pushed branch tip is behind its remote

hint: counterpart. Check out this branch and integrate the remote changes

hint: (e.g. 'git pull ...') before pushing again.

hint: See the 'Note about fast-forwards' in 'git push --help' for details.

解决方法：

先 

git pull origin Feature-Pub_Sub，把文件merge了

再push

ssh for git

https://help.github.com/articles/generating-ssh-keys/

gitlab 教程

http://blog.csdn.net/zy416548283/article/details/38057925

Fingerprint has already been taken
Fingerprint cannot be generated

这个错误就把key里的空格，空行都删掉

database 死活都连不上，一开始的connection都建立不了

conn = DriverManager.getConnection(makeURL(), username, password);   exception:

Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

先安装数据库，在redhat上启用数据库先

http://www.postgresql.org/download/linux/redhat/

启动数据库

https://wiki.postgresql.org/wiki/PostgreSQL_on_RedHat_Linux

https://wiki.postgresql.org/wiki/Client_Authentication

数据库启动了又有另一个问题

2015-11-10 12:29:12,652 ERROR ca.utoronto.msrg.padres.broker.controller.db.DBConnector.initDatabase(Unknown Sou    rce) Failed to start up the database: Backend start-up failed: FATAL:  role "padres" does not exist

新建一个role

psql -U postgres

But the first step is to check the missing role: What is the output within psql of the command \du ? On my Ubuntu system the relevant line looks like this:

                              List of roles
 Role name |            Attributes             | Member of 
-----------+-----------------------------------+-----------
 postgres  | Superuser, Create role, Create DB | {}        

基本操作

http://www.ruanyifeng.com/blog/2013/12/getting_started_with_postgresql.html

更改表的 owner

ALTER DATABASE postgres OWNER TO padres;