tutorials icon indicating copy to clipboard operation
tutorials copied to clipboard

error connecting to the DB

Open AbBiz101 opened this issue 2 years ago • 0 comments

I followed the instructions given on the pdf but it is showing me this error. Could you please help me?

[16:18:26 INFO] Connecting to database 'Berlin model'. [16:18:27 ERROR] Connection to database could not be established. [16:18:27 ERROR] Caused by: java.sql.SQLException: Failed to retrieve version information from the 3D City Database instance. [16:18:27 ERROR] Caused by: org.postgresql.util.PSQLException: ERROR: schema "citydb_pkg" does not exist Position: 15

also on when I run CREATE_DB.bat it shows me this error

Connecting to "[email protected]:5432/CityModelX" ... Password for user postgres:***** SET postgis_version

3.1.4

postgis_raster_exists

f

  do_action_for_raster_extension_check

UTIL/HINTS/HINT_ON_MISSING_RASTER_EXTENSION.sql

psql:UTIL/HINTS/HINT_ON_MISSING_RASTER_EXTENSION.sql:33: ERROR: The postgis_raster extension is missing! HINT: This extension is required when the target database uses PostGIS 3 or higher. CONTEXT: PL/pgSQL function inline_code_block line 3 at RAISE Press any key to continue . . .

AbBiz101 avatar Oct 28 '21 14:10 AbBiz101