Azure PostgreSql , extension postgis
I try to upoad backup file to azure postrgesql server, but I got an error
psql:E:/PostgreSqlBackups/WeatherDb/weatherDb_11_08_2023.sql:26: ERROR: extension "postgis" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL
In the server parameters I have : postgis.gdal_enabled_drivers ENABLE_ALL
How can I solve this?
Solution
When I tried to replicate the issue in my environment, I got the same error in my environment:
To solve the error, I followed below procedure:
Go to server parameter and search for azure extensions, select POSTGIS and save it as mentioned in below image:
After that I tried to upload backup file into PostgreSQL database using below command:
psql -h <serverName>.postgres.database.azure.com -U <serverAdminLoginName> -d <dbName> -f <backupfile path>
The file is restored to the PostgreSQL database successfully:
- How to scan into nested structs with sqlx?
- Allow IPs with TCP Listener using RBAC (Envoy)
- Postgres: Add constraint if it doesn't already exist
- UPDATE Statement ignores INNER JOIN
- Change default schema for user
- How to user "smart query conditions" in MikroORM in many-to-many relations #6250
- I want to insert with mikro-orm, but it dont find my table :c (TableNotFoundException)
- PostGIS Installation "could not open extension control file"
- Insert missing rows in time series consumption history
- Why do I received a "invalid byte sequence " when calling a function through pg_background (encoding WIN1252)?
- Entity Framework Core : check if comma-separated string contains any value from list
- How to autofill a field with data from another field in the same table?
- Installing pg -v 1.2.3 using ARCHFLAGS on mac chip
- Conditional PostgreSQL foreign key
- Why is there no rows for 'SHOW config_file' in PostgreSQL database?
- How to use Django BinaryField to store PNG images in postgres?
- How to create a uint256 in PostgreSQL
- Liquibase and functional index
- Update a JSON property in a text column that contains a JSON object
- How can I ensure efficient partition pruning when using dates from subqueries?
- IIF in postgres
- PostgreSQL CREATE USER - need for single quotes around password, no quotes for username
- PostgreSQL - Find row data size in GB, for each five-year period
- Is there any difference between CTE INSERT+UPDATE in one go versus two different queries
- Dynamically generate columns for crosstab in PostgreSQL
- Access and return result from INSERT INTO in PL/pgSQL function
- Postgres restore tables from a dump into a different schema
- Ruby on Rails / PostgreSQL - Library not loaded error when starting server
- Why does Postgres not use the index when the comparison value is derived from my function?
- Why does database not read from newly inserted data when a single query is doing both write and read?