Users and roles in Managed Service for PostgreSQL

Can I migrate users from a PostgreSQL source cluster to a Managed Service for PostgreSQL destination cluster?Can I migrate users from a PostgreSQL source cluster to a Managed Service for PostgreSQL destination cluster?

No, you cannot automatically migrate users from a third-party PostgreSQL cluster or Managed Service for PostgreSQL cluster to a Managed Service for PostgreSQL cluster. You will need to re-create the users in the target cluster.

How to create a role using SQL queries?How to create a role using SQL queries?

You cannot create a role using SQL queries.

In PostgreSQL, a role is a database user or group of users. In Managed Service for PostgreSQL, you can create a user only via the management console, Yandex Cloud CLI, Terraform, or API. For more information about creating users, see this PostgreSQL guide.

You can assign user privileges, which decide the actions the user can perform with database objects.