Implement PostgresSQL support.

[Audrunas]

Research, maybe there are free / trial / cheap web services, such as Azure SQL server, which hosts PostgreSQL / Oracle databases.

Ref #372

[Audrunas]

PostgreSQL: https://openhosting.cloudpostgres.com/auth/login Oracle: https://cloud.oracle.com/mycloud/f?p=service:home:0

[ghost]

Work in progress: https://github.com/devbridge/BetterCMS/tree/dev-postgre-support

Service can be used for testing:

• https://postgres.heroku.com/ With connection string like:
• connectionString="Server=[server];Port=[port];Userid=[userid];Password=[password];Protocol=3;SSL=false;Pooling=false;MinPoolSize=1;MaxPoolSize=20;Timeout=15;SslMode=Require;Database=[databasename]"

Current findings:

• only Postgre 8.2 and new can be supported (because of UUID)
• uuid-ossp extension needs to be added to DB (http://stackoverflow.com/questions/12505158/generating-a-uuid-in-postgres-for-insert-statement)
  • FluentMigrator Create.UniqueConstraint fails, because it does not append schema name in front of table name.
  • FluentMigrator in one of version checks generates a query in small cases (Postgre is case sensitive)