Add support for Postgres

[dmadunic]

in addition to h2, Petclinic app comes with support for mysql, it would be nice to have similar support for the second (maybe first ;-)) most popular open source database Postgres.

Support can be done along the same lines as the one for mysql, namely to add the following files and folders:

• resources/
  • application-postgres.properties
  • db/
    • postgres/
      • data.sql
      • schema.sql

And finally, posgres jdbc driver should be added to the runtime dependencies in pom.xml

I have also attached to this issue all of the above files, for review.

resources.zip
schema.sql

[arey]

@dmadunic if you are interested, to prepare a Pull Request, you could look at the legacy version spring-petclinic/spring-framework-petclinic that support PostgreSQL (see the readme.md)

[dmadunic]

I think that I have already done the major part of the work, so sure I would be glad to prepare a Pull request.

I have tested it and run it locally, so it should not be much of an effort.

[arey]

Ok great. Before that wait a response from @dsyer or @snicoll

[snicoll]

Feel free to submit a PR and we can take it from there.

[nroi]

I'd like to revive this topic. It's been over a year since the last reply, so I hope it's ok that I just went ahead and submitted a PR.

[lynchmaniac]

@nroi what a synchronicity, I just also posted a PR too on the same subject. 😃

Cool, hoping the code is merged.

[nroi]

@lynchmaniac aah, what are the chances, after more than a year of silence, two PRs are posted just 3 minutes apart 😄

[dsyer]

Resolved via #878