Configure Postgres on a VPS

[TimvdLippe]

Install a VPS on DigitalOcean in order to run a database and server on.

[jwgmeligmeyling]

Could not connect to postgres from outside, are these steps taken? http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html I could not take the steps because I don't have the password for postgres and I think moodcat is not in sudoers?

[Jaapp-]

Moodcat has been added to sudoers, remote connections are now allowed and password protected.

[jwgmeligmeyling]

Postgres is set up well. Have been able to push some data. I created a PR #55 for the correct Hibernate settings.

moodcat_db=# select * from song
moodcat_db-# ;
 id | expected_arousal | expected_valence | average_loudness | mean_dissonance | bpm | key_key | key_scale | key_strength | tuning_frequency |          name           | arousal | valence | artist_id 
----+------------------+------------------+------------------+-----------------+-----+---------+-----------+--------------+------------------+-------------------------+---------+---------+-----------
  1 |                  |                  |                  |                 |     |         |           |              |                  | Thanks for the Memories |         |         |         1
(1 row)

moodcat_db=# \d
              List of relations
 Schema |     Name      |   Type   |  Owner  
--------+---------------+----------+---------
 public | artist        | table    | moodcat
 public | artist_id_seq | sequence | moodcat
 public | song          | table    | moodcat
 public | song_id_seq   | sequence | moodcat
(4 rows)