HammerDB TPROC-C Schema Build script for Azure Database for PostgreSQL flexible server #784
-
|
Hello, HammerDB TPROC-C Schema Build script requires PostgreSQL Superuser however Azure Database for PostgreSQL flexible server does not allow to connect or create superuser. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
Found workaround: |
Beta Was this translation helpful? Give feedback.
-
|
Many thanks for taking the time to provide the answer when you found it, this is always very much appreciated and helps others with the same issue 🙏 |
Beta Was this translation helpful? Give feedback.
Found workaround:
As shown in https://medium.com/@dmitry.romanoff/postgresql-version-15-error-permission-denied-for-schema-public-dc8285c41e00
from Postgres version 15 it is now necessary to grant permissions on SCHEMA public to a user explicitly.
So after you run the Build script (as psql_admin) 1st time it will create both tpcc db and tpcc user (and tpcc user will be owner of tpcc db)
but fail with:
"Error in Virtual User 1: Error: ERROR: permission denied for schema public
LINE 1: CREATE TABLE CUSTOMER (C_SINCE TIMESTAMP WITH TIME ZONE NOT ..."
then you need to connect to tpcc db and run:
tpcc=> GRANT ALL on SCHEMA public to tpcc;
then re-run the Build script which now completes succes…