tutorials
tutorials copied to clipboard
error connecting to the DB
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 . . .