Question

No FME Server Database after 2022.2 in place upgrade on Ubuntu 20.04.5 with existing PostGreSQL 15.2 installation.

  • 14 February 2023
  • 2 replies
  • 1 view

Badge +4

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


2 replies

Badge +5

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;

Badge +4

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