Azure-Samples / Azure-Samples/azure-python-labs

[01-postgres] Add instructions to allow-list the postgis extension

未关闭
#81 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Python
星标
175
派生
107
PR 合并指标
30 天内没有已合并 PR

描述

Error via Microsoft Open Source Discord:

```
File ".\azure-python-labs\01-postgres\pg-lab.py", line 30, in loadData
cursor.execute('CREATE EXTENSION IF NOT EXISTS postgis')psycopg2.errors.FeatureNotSupported: extension "postgis" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL
HINT: to see the full allow list of extensions, please run: "show azure.extensions;"
```

The extension will need to be allow-listed per https://docs.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions#how-to-use-postgresql-extensions

贡献指南

打开贡献指南

调研方向

Start with 01-postgres/pg-lab.py, especially the loadData entry point around line 30, and read the linked Azure Database for PostgreSQL extension instructions. Add the allow-listing steps for postgis before the CREATE EXTENSION command. Done means the lab instructions explain how to avoid the azure_pg_admin error.

由索引模型根据 Issue 内容生成。

评估

技术栈
azure, postgresql, python
领域
cloud, databases, documentation
Issue 类型
文档
难度
2/5
预计耗时
1-3 小时
活跃度
停滞
描述清晰度
基本清楚
新手友好度
48/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。