SQL command limits

Managed Service for PostgreSQL has some limitations on DB owner actions when using SQL commands:

• You cannot change the PostgreSQL settings.
• You cannot manage users or create and assign roles to them. However, you can grant user privileges at the level of individual DB objects.
• You cannot create databases; however, DB owners and users with the mdb_admin or mdb_superuser role can run the ALTER DATABASE command for a previously created DB.
• You cannot manage PostgreSQL extensions.
• No actions that require superuser privileges are allowed.

You can, however, perform all these actions using the Yandex Cloud tools. To learn how, check out our step-by-step guides.