make sure rasdaman with postgres compiles and passes systemtest

[Dimitar Misev]

1. Configure rasdaman with postgresql backend (instead of sqlite)
   • cmake ... -DDEFAULT_BASEDB=postgresql
2. Build with make/make install
   • it may require fixing compilation in *.pgc files in rel* source directories
   • especially with axis names, see changeset:7a60837d3bb57f799abb064e0470d0e39afba2f5 which only updates the sqlite *.sc files and not *.pgc
3. Initialize db with create_db.sh and update_db.sh
   • check ​this first
4. Run systemtest and fix possible issues

[apercov]

Both Rasdapy and Rasdapy3 work unreliably with postgres. Rasdapy3 cannot pass the testcases due to that. Should I continue work on that in this ticket, or should I open another ticket for that and just disable Rasdapy3 test for postgres?

[Dimitar Misev]

I suggest open a new ticket with priority minor.

[apercov]

Important note: Test_manipulation fails every time in RELEASE on my local machine. Few times it corrupted the db, other times it went to deadlock state (my assumption). To see that the transaction gets stuck, you can open psql command line, connect to RASBASE(or any other name of base DB that you are using), and run the following query:

SELECT * FROM pg_stat_activity WHERE datname = current_database() AND pid <> pg_backend_pid() AND state LIKE 'idle%';