Add support for PostgreSQL database

[php-coder]

• adapt application to work with PostgreSQL
• fix the migrations
• review and fix the sequences
  • users_id_seq
  • series_id_seq
  • collections_id_seq
  • transaction_participants_id_seq
  • series_sales_id_seq
  • site_parsers_id_seq
  • images
  • *_catalog
• review and ensure that we don't insert ids with prod profile
• run integration tests on PostgreSQL as well (extracted into Travis CI: run tests on PostgreSQL #1054)
• add separate docker-compose file
• update README.md/NEWS.txt files

[php-coder]

It doesn't start because one of migrations fails:

2019-06-06 01:32:03.476 WARN 1 --- [ main] ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:/liquibase/version/0.3/2014-02-11--categories.xml::initiate-categories-table::php-coder:
Reason: liquibase.exception.DatabaseException: ERROR: syntax error at or near "$"
Position: 162 [Failed SQL: INSERT INTO public.categories (id, name, name_ru, created_at, created_by, updated_at, updated_by) VALUES ('1', 'Prehistoric animals', 'Доисторические животные', ${NOW}, '2', ${NOW}, '2')]

[php-coder]

UPDATE: this error happens only when "test-data" context is active in Liquibase (that means that the test and travis profiles should be affected by that).

[php-coder]

After fixing the previous issue (by declaring NOW property properly), the new issue appear:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfigura
tion$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:/liquibase/version/0.3/2
014-05-28--release_month_and_day.xml::fill-release_year-column-based-on-values-from-released_at::php-coder:
Reason: liquibase.exception.DatabaseException: ERROR: function year(date) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 35 [Failed SQL: UPDATE series
SET release_year=YEAR(released_at)
WHERE released_at IS NOT NULL]

[php-coder]

The next error is:

Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set classpath:/liquibase/version/0.3/2014-09-28--collection_slug.xml::update-collections-slug::php-coder:
Reason: liquibase.exception.DatabaseException: ERROR: column "c" of relation "collections" does not exist
Position: 29 [Failed SQL: UPDATE collections c
SET c.slug = (
SELECT LOWER(REPLACE(u.login, ' ', '-'))
FROM users u
WHERE u.id = c.user_id
)]

[php-coder]

The next error is:

Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set classpath:/liquibase/version/0.4/2015-06-22--image_url.xml::fill-series_images-table-based-on-values-from-image_url::php-coder:
Reason: liquibase.exception.DatabaseException: ERROR: column "image_id" is of type integer but expression is of type text
Hint: You will need to rewrite or cast the expression.
Position: 75 [Failed SQL: INSERT INTO series_images(series_id, image_id)
SELECT id AS series_id, REPLACE(image_url, '/image/', '') AS image_id
FROM series]