Azure-Samples / Azure-Samples/rag-postgres-openai-python
[HELP] - unable to connect to db using psql or pgadmin
- Ngôn ngữ chính
- Python
- Star
- 505
- Fork
- 1.1k
- Merge trung bình
- 3 ngày 13 giờ
- Pull request đã merge (30 ngày)
- 1
Mô tả
I was running the demo in **codespace**
I followed the guide to export the token generated as password
`export PGPASSWORD={"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI...........VPNUlKeXlxUjZqekRTNWlBYnBlNDJKdyJ9"}`
and then run the following
`$ psql -h $(azd env get-value POSTGRES_HOST) -U $(azd env get-value POSTGRES_USERNAME) -d $(azd env get-value POSTGRES_DATABASE) -p 5432`
but getting this error:
```
psql: error: connection to server at "justin-test-3a*****bi-postgresql.postgres.database.azure.com" (172.177.167.194), port 5432
failed: FATAL: The access token has invalid format.
Please ensure the token is passed exactly as returned by the authentication endpoint and retry.
connection to server at "justin-test-3a******zbi-postgresql.postgres.database.azure.com" (172.177.167.194), port 5432
failed: FATAL: no pg_hba.conf entry for host "20.227.141.210", user "adminupjcfh45d******" database "postgres", no encryption
```
Hướng dẫn đóng góp
Đánh giá
Issue này chưa được đánh giá.