How to use Hyperscale (Citus) server group of azure postgres?

Question

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

Answer 1

Hi @Uday Kiran Reddy (ureddy)

Thank you for posting your Question on Microsoft Q&A and for using Azure services.
If my understanding is correct, you are getting an error message when creating a database in PostgreSQL Citus.

We don’t support multiple DBs in Hyperscale (Citus). You should use the pre-defined ‘citus’ DB. You can use multiple Postgres schemas inside that DB.

This product limitation is documented here.

Regards,
Oury