Im running VP on my PC and the Postgres DB on a different local server. I have been able to generate the database before but now i keep running into errors.
Generating the database seems to crash the postgres server.
VP gives me the following:
Export to database failed…
org.postgresql.util.PSQLException: This connection has been closed.Generate database finish…
In my postgres log file i can see that an error occured but its not clear to me why i occurs:
2018-10-11 17:48:28.739 CEST  LOG: server process (PID 30680) was terminated by signal 9: Killed
2018-10-11 17:48:28.739 CEST  DETAIL: Failed process was running: SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, pos.n AS KEY_SEQ, CASE con.confupdtype WHEN ‘c’ THEN 0 WHEN ‘n’ THEN 2 WHEN ‘d’ THEN 4 WHEN ‘r’ THEN 1 WHEN ‘p’ THEN 1 WHEN ‘a’ THEN 3 ELSE NULL END AS UPDATE_RULE, CASE con.confdeltype WHEN ‘c’ THEN 0 WHEN ‘n’ THEN 2 WHEN ‘d’ THEN 4 WHEN ‘r’ THEN 1 WHEN ‘p’ THEN 1 WHEN ‘a’ THEN 3 ELSE NULL END AS DELETE_RULE, con.conname AS FK_NAME, pkic.relname AS PK_NAME, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS DEFERRABILITY FROM pg_catalog.pg_namespace pkn, pg_catalog.pg_class pkc, pg_catalog.pg_attribute pka, pg_catalog.pg_namespace fkn, pg_catalog.pg_class fkc, pg_catalog.pg_attribute fka, pg_catalog.pg_constraint con, pg_catalog.generate_series(1, 32) pos(n), pg_catalog.pg_class pkic WHERE pkn.oid = pkc.relnamespace
2018-10-11 17:48:28.739 CEST  LOG: terminating any other active server processes
2018-10-11 17:48:28.740 CEST  WARNING: terminating connection because of crash of another server process
2018-10-11 17:48:28.740 CEST  DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2018-10-11 17:48:28.740 CEST  HINT: In a moment you should be able to reconnect to the database and repeat your command.
Does anyone have any experience with this?
The only other topic i could find mentioned it fixed itself, but that doesnt really help all that much