Thread: proj_create errors in EDB 13.5 installation macOS

proj_create errors in EDB 13.5 installation macOS

From
"Moen, Paul T."
Date:

I am seeing the following errors in my PostgreSQL log files and wonder if this is a problem with EDB's installation. 

 

proj_create: Cannot find proj.db

proj_create: no database context specified

proj_create: Cannot find proj.db

proj_create: no database context specified

proj_create: Cannot find proj.db

proj_create: no database context specified

proj_create: Cannot find proj.db

proj_create: no database context specified

proj_create: Cannot find proj.db

proj_create_operation_factory_context: Cannot find proj.db

pj_obj_create: Cannot find proj.db

proj_create_operation_factory_context: Cannot find proj.db

pj_obj_create: Cannot find proj.db

proj_create_operation_factory_context: Cannot find proj.db

pj_obj_create: Cannot find proj.db

proj_create_operation_factory_context: Cannot find proj.db

pj_obj_create: Cannot find proj.db

proj_create_operation_factory_context: Cannot find proj.db

pj_obj_create: Cannot find proj.db

 

I used the EDB installer for 13.5 from www.enterprisedb.com/downloads/postgres-postgresql-downloads

 

macOS Monterey 12.1 Darwin 21.2.0 Darwin Kernel Version 21.2.0: Sun Nov 28 20:28:54 PST 2021; root:xnu-8019.61.5~1/RELEASE_X86_64 x86_64

psql (PostgreSQL) 13.5

POSTGIS="3.0.2 2fb2a18" [EXTENSION] PGSQL="130" GEOS="3.8.1-CAPI-1.13.3" PROJ="7.1.1" LIBXML="2.9.10" LIBJSON="0.15"

 

 

Any suggestions?

 

Paul

Re: proj_create errors in EDB 13.5 installation macOS

From
Paul Ramsey
Date:

> On Jan 21, 2022, at 4:45 AM, Moen, Paul T. <pmoen@nd.gov> wrote:
>
> I am seeing the following errors in my PostgreSQL log files and wonder if this is a problem with EDB's installation.

Yes, missing the proj.db would certainly make proj unhappy. Search your system first and see if the file is actually
there.Maybe it's there but not being found, in which case some extra environment variables could make your install turn
over.But EBD perhaps needs to make sure that it's both (a) included and (b) found on startup. 

P