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
Question
No FME Server Database after 2022.2 in place upgrade on Ubuntu 20.04.5 with existing PostGreSQL 15.2 installation.
+4
+5- Safer
- 89 replies
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;
+4Hello,
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