Skip to main content

SetupPostGreSQL.log has the following error returned for each command:

...Permission denied for schema Public.

 

This is the same setup which has been in use for Server 2021

 

Thank you in advance!

Brek

Hello,

 

This is a known issue that has been planned for a later release. To confirm, this error is faced when following the install instruction to run postgresql_createDB.sql script ?

As a workaround, would you be able to make this change to the said script and run it -

Remove

GRANT ALL PRIVILEGES ON DATABASE fmeserver TO fmeserver;

Add

ALTER DATABASE fmeserver OWNER TO fmeserver;


Hello,

 

This is a known issue that has been planned for a later release. To confirm, this error is faced when following the install instruction to run postgresql_createDB.sql script ?

As a workaround, would you be able to make this change to the said script and run it -

Remove

GRANT ALL PRIVILEGES ON DATABASE fmeserver TO fmeserver;

Add

ALTER DATABASE fmeserver OWNER TO fmeserver;

Hi Merlin thank you for the assistance!

I can update the file as suggested but not sure how to call it outside the installation environment.

I've attached a document with the steps taken during the installation and the resulting logs


Reply