We are able to use postgres flexible server and standalone server types.
But, with postgres Hyperscale (Citus) server group, the sql queries are not running.
When I try to run them, I am getting these errors below, for all workers and also controller node.
psql "host=c.devtestlargepostgres.postgres.database.azure.com port=5432 dbname=citus user=citus password={your_password} sslmode=require"
citus=> create database martdatabase;
NOTICE: Citus partially supports CREATE DATABASE for distributed databases
DETAIL: Citus does not propagate CREATE DATABASE command to workers
HINT: You can manually create a database and its extensions on workers.
ERROR: permission denied to create database
when I connect to worker node:
psql "host=w0.devtestlargepostgres.postgres.database.azure.com port=5432 dbname=citus user=citus password={your_password} sslmode=require"
citus=> create database martdatabase;
NOTICE: Citus partially supports CREATE DATABASE for distributed databases
DETAIL: Citus does not propagate CREATE DATABASE command to workers
HINT: You can manually create a database and its extensions on workers.
ERROR: permission denied to create database
Also, what extra connection configuration we need to do from our java application when we want to use this database other than the flexible server