How to Terraform import azurerm_postgresql_active_directory_administrator for a postgresql flexible server on Azure
I created a PostgreSQL flexible server on Azure manually, since there is an error creating it through Terraform. When creating the flexible server, there is an option to select AAD Server admin:
After creating the whole resource, I am trying to import it into Terraform.
For specifying the AAD Server admin, I tried using the following resource: "azurerm_postgresql_active_directory_administrator". For that resource, the import command that is available inside the documentation would be:
terraform import azurerm_postgresql_active_directory_administrator.administrator /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.DBforPostgreSQL/servers/myserver
My question is, is there an alternative for this, can this "azurerm_postgresql_active_directory_administrator.administrator" resource even be used for flexible servers? Does it need to be used?
I tried using my flexible servers resource ID, but I get the following error:
Expected a Server ID that matched: │ │ > /subscriptions/12345678-1234-9876-4563-123456789012/resourceGroups/example-resource-group/providers/Microsoft.DBforPostgreSQL/servers/serverValue │ │ However this value was provided: │ │ > /subscriptions/<my__sensitive_subscription_id>/resourceGroups/hrpap-dev-db-postgres-rg/providers/Microsoft.DBforPostgreSQL/flexibleServers/hrpap-dev-db-postgres-database-flex/administrators/<object_id> │ │ The parsed Resource ID was missing a value for the segment at position 6 │ (which should be the literal value "servers").
Apparently, there is a new resource for that, with a little bit different configuration required:
- ruby raised another command is already in progress
- Find modal values in each row, with custom tie breaking in PostreSQL
- Find procedure name in all other procedures
- How to use posix regexp operator for substring match
- How to get results from a Postgresql function using EF Core?
- Sql Alchemy Insert Statement failing to insert, but no error
- SELECT rows with the max count per column value after GROUP BY
- Pick random values from different table-columns (postgresql)
- django.db.utils.ProgrammingError: relation "bot_trade" does not exist
- Supabase python client returns an empty list when making a query
- How to calculate DATE Difference in PostgreSQL?
- Repeat rows specified number of times in PostgreSQL
- How to visualize database tables in postgresql using pgAdmin?
- panic: sql: expected 1 destination arguments in Scan, not <number> golang, pq, sql
- Why is Postgres not using my index on a simple ORDER BY LIMIT 1?
- Npgsql: How to setup enum mapping in Npgsql v8?
- How to reference another docker service from Dockerfile
- How to differentiate a Cypher clause from an SQL clause in C?
- using sql joins vs using separated methods in java
- Prisma Supabase: Invalid format for user or db_name after initial migration
- Laravel Model casts not working properly
- Export specific rows from a PostgreSQL table as INSERT SQL script
- Retaining and inserting state into a postgres aggregation function
- Spring JPA with docker compose: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' or 'hibernate.dialect'
- PostgreSQL - ERROR: column does not exist SQL state: 42703
- Function to return dynamic set of columns for given table
- How to force evaluation of subquery before joining / pushing down to foreign server
- How to install postgresql-client to Amazon EC2 Linux machine?
- Unterminated dollar-quoted string reported by goose when creating PostgreSQL function
- How to compute the sum of multiple columns in PostgreSQL