error connecting to the DB #3
Description
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 "postgres@127.0.0.1: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 . . .