Error loading GeoTIFF using raster2pgsql: "Error 1: PROJ: Cannot find proj.db"

Question

I am attempting to load a GeoTiff into a PostgreSQL database using the PostGIS extension raster2pgsql. When running the executable, I receive the following error: Error 1: PROJ: Cannot find proj.db. The only file with that name resides in the path C:\Program Files\PostgreSQL13円\share\contrib\postgis-3.0\proj. I've added that path to my Path variable in my environment settings, but running raster2pgsql still returns the same error. I then get a message saying the program raster2pgsql has stopped working.

This is the command I'm running in Command Prompt. I've put placeholder user/database names in quotes. If any syntax is incorrect or doesn't make sense please inform me:

raster2pgsql -I -C C:\Users\Administrator\Desktop\arcgis-data\ "tifname".tif | psql -h "hostname" -p 5432 -d "database name" -U "username"

Answer 1

Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. Answers without enough detail may be edited or deleted.

I believe you need to specify the path to proj.db in an PROJ_LIB environment variable.

See proj documentation

• Tony: Thank you, that worked!