Azure Database for PostgreSQL server: no pg_hba.conf entry for host
In my Azure portal I created the resource "Azure Database for PostgreSQL server". I set up the firewall to enable two Virtual Networks (in order to allow the correct functioning of two applications) and the IP address of my local computer (in order to be able to work on the database using DBeaver as client). This has worked for several months although, since I have a dynamic IP address, I often have to change the enabled address. Now I'm trying to update it but, when I try to connect to the database via DBeaver, I get the following error:
FATAL: no pg_hba.conf entry for host "XX.XX.XX.XX", user "myuser", database "mydatabase", SSL on
where "XX.XX.XX.XX" is exactly the IP address I have enabled in Azure.
I tried to install a second Client (pgAdmin) but I get the same error. Also, since my applications that use the database seem to work properly, I tried to verify the connection data that I use in DBeaver (host, database, user, password) but they are all correct.
In Azure, in the "Connection security" tab of my database (see image below) I read the following warning:
Some network environments may not report the actual public-facing IP address needed to access your server. Contact your network administrator if adding your IP address does not allow access to your server.
So changing the IP address has no effect? How can I solve the problem?
I solved the problem by restarting the database: https://learn.microsoft.com/en-us/azure/postgresql/howto-restart-server-portal
- database design of a family and how to insert into database
- Laravel: Selecting all films where the condiction is in another table
- wordpress mysql - delete all custom post type
- How to open file maker .fp3 files without file maker installed?
- How to restrict RLS on certain column(s) in PostgreSQL/Supabase?
- How to use stored procedure parameters as dynamic content in copy activity using ADF
- NLOG Database Target can't connect
- SQL Database in restoring mode
- Add PRIMARY KEY constraint to existing table
- How to debug a database query for performance
- LocalDB is not supported on this Platform
- Store images in a MongoDB database
- How to pass stored procedure parameters as dynamic content in copy activity using ADF
- Normalization of vehicle data
- sqlite's fetchall returns None instead of an empty list
- How do I join 2 SQL tables in python based on their (non-unique) ID and closest values in years?
- connect superset to postgresql in a docker container - The port is closed
- Is there a way to get a list of column names in sqlite?
- What happens when you insert rows in a SERIAL column with existing values?
- Relational Algebra Intersection Properties
- MySQL insert country iso or country id from another table
- Error: supabaseUrl is required (supabase) postgresql
- How do I alter the position of a column in a PostgreSQL database table?
- Utilizing Sqlite `no such table` error in Go?
- What this warning means `Required tables DBMSHP_FUNCTION_INFO,DBMSHP_PARENT_CHILD_INFO,DBMSHP_RUNS missing`
- Superset: command not found
- How do you interpret a query's explain plan?
- What is the difference between the different BerkeleyDB versions, and which should I choose?
- How to select bottom most rows?
- Export and Import all MySQL databases at once