Azure PostgresSQL hyperscale citus - Modify the password policy

Honey Nadackal 126 Reputation points
2020-09-17T11:17:56.417+00:00

We are moving Azure postgres single server instance to hyperscale mode. On hyperscale postgres , as per documentation roles need to be created from portal .I need clarification on following
1)Is it possible to create user / role from psql
2)Is there a way to bypass the password policy when we create new roles. Our application has multiple roles which has password that doesnt comply with password policy.- Caps,special character validation..
3)Is it possible to migrate the single server DB to hyperscale instance?

Azure Database for PostgreSQL
Accepted answer
  1. Anurag Sharma 17,586 Reputation points
    2020-09-21T08:04:54.187+00:00

    Hi @Honey Nadackal , welcome to Microsoft Q&A forum. Please check below for your queries:

    1. The server admin user account can be used to create additional users and grant those users into the azure_pg_admin role. Also, the server admin account can be used to create less privileged users and roles that have access to individual databases and schemas. please refer to below article:
      https://video2.skills-academy.com/en-us/azure/postgresql/howto-create-users
    2. Currently there looks no way to override the password policy in Azure Postgresql
    3. Yes you can migrate the database from single server to hyperscale. Below is the step by step tutorial for the same.
      https://video2.skills-academy.com/en-us/azure/dms/tutorial-azure-postgresql-to-azure-postgresql-online-portal

    Please let us know if this answers your queries.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest