PostgreSQL support

[sonicaghi]

We should support other datastores than Cassandra which is primarily aimed at users who want to benefit from its distribution capabilities.

Support for PostgreSQL seems the best candidate for the second datastore, due to its popularity, availability on Amazon RDS and reliability. It is also a very good fit for Kong due to its relational nature.

[sonicaghi]

Related to #183

[thorstenz]

+1 for PostgreSQL support.
very good experience with the jsonb datatype.

[vishalraina]

+1

[bhameyie]

+1

[MattCollinge]

+1

[skippy]

+1

[wsimmonds]

+1

[obsidienne]

+1

[lucamaraschi]

👍 👍

[sent-hil]

👍

[matti]

👍

[ahmadnassri]

👍

[vivekfantain]

+1

[owahlen]

+1

[coreybutler]

+1

[ngbinh]

👍

[bigpg]

+1

[udleinati]

+1

[avtar]

👍

[vwal]

+1

[bkleef]

+1

[edurdias]

+1

[devton]

+1

[mgooty]

+1

[RolfKoenders]

We are using 9.4 as well, on RDS.

[pklingem]

9.4 is great for us.

[C4]

Like others, Not using Postgres right now. But something RDS backed would be awesome.

[lindo-jmm]

Not on AWS (Azure), but I have 9.5 running on a server. Love it!

[nhuray]

+1

[kenwarner]

9.4 on RDS is our use case as well.

[dempe]

👍 Any version would be fine for us.

[protetore]

We're using 9.3 on RDS.

[stramel]

+1, RDS would be great as well

[derrickburns]

👍

[shaikhfaisal]

+1 RDS support would be awesome

[mjhlobdell]

+1

[lsmith77]

@thibaultcha is there an ETA? also is there already a PR to try out your current state?

[jkwong]

+1

[sathyavijayan]

+1

[eseres]

+1

[bramswenson]

👍

[gianlucatomasino]

+1

[nickmcintyre]

+1

[indigostar-kr]

+1

[jaceq]

Is there maybe any update on this topic?

[BrianHutchison]

+1 for Amazon DynamoDB.

[thibaultcha]

Hey everyone,

The implementation is almost complete, the branch now lives in this repository (See feature/postgres). As planned, Postgres 9.4 is supported so Amazon RDS should be supported as well, I briefly played with it but it needs to be tested more in-depth once the implementation is complete. Btw, testers are welcome here!

What is missing:

• Full support for OAuth2 and clustering. Right now those implementations relied on Cassandra rows with TTLs, so right now with Postgres, things don't expire as they would do with Cassandra. This should soon be resolved. This blocks production usage but not simple testing of the feature.
• Support for SSL connections between Kong and Postgres. As of now, a Pull Request is pending at feat: implement support for SSL connection leafo/pgmoon#24 with support for it. If it gets approved, that should be resolved too.
• A lot of documentation updates!

How to test it (if you want to try it out or just a glimpse of how to use it):

• Get your hands on a 9.4+ server
• Create a database, (maybe a user too?), let's say kong
• Use the feature/postgres branch of Kong (you must have a source install for this)
• Update your Kong configuration:

# be careful about your YAML formatting
database: postgres
postgres:
  host: "127.0.0.1"
  port: 5432
  user: kong
  database: kong

As usual, migrations should run from kong start, but as a reminder and just in case, here are some tips:

Reset the database with (careful, you'll lose all data):

$ kong migrations reset --config kong.yml

Run the migrations manually with:

$ kong migrations up --config kong.yml

If needed, list your migrations for debug purposes with:

$ kong migrations list --config kong.yml

If you test it, feel free to report any issues (please not here, but in a new issue in this repo) :)

Thank you all for your patience!

[geovanisouza92]

+1

[subnetmarco]

This feature will land in v0.8.

[subnetmarco]

You can play with v0.8.0 with Postgres support at https://github.com/Mashape/kong/releases/tag/0.8.0 - we will update Docker and the website soon.

[subnetmarco]

Kong 0.8.0 announced: http://blog.mashape.com/announcing-kong-0-8-0-with-postgresql-support/

Enjoy :)