1844

Postgres pgAdmin III Access to Database Denied

Question:

I get the following error when attempting to connect to the Postgres instance on my server.

<em>Access to database denied The server doesn't grant access to the database: the server reports FATAL: no pg_hba.conf entry for host "fe80::2d93:af94:879c:4fa%12", user "postgres", database "postgres", SSL off</em>

I have tried the three obvious solutions found <a href="https://stackoverflow.com/questions/1287067/unable-to-connect-postgresql-to-remote-database-using-pgadmin" rel="nofollow">HERE</a>. Namely I attempted Syed Aslam solution found in that^ link.

I tested that I was restarting the service correctly by removing some config to break my local pgAdmin III connection. I have checked if my firewall was blocking the connection by temporarily turning it off.

Can anyone help me figure out why I am getting this error?

Postgres 9.4.1 <br /> pgadmin III version 1.20 <br /> Windows Server 2012 (host)<br /> Windows 7 (trying to connect from this to the host)

Answer1:

It turns out that I had an IPv4 as the IP address in my entry for the pg_hba.conf. After changing it to an IPv6 version like this:

IPv4 = 0.0.0.0/0 IPv6 = ::/0

It all worked as I would have expected. The comment from user_0 and the documentation found <a href="http://www.postgresql.org/docs/9.4/static/auth-pg-hba-conf.html" rel="nofollow">HERE</a> cleared it up for me.

Obviously the answer works in reverse if you're using an IPv6 when you should be using an IPv4.

Recommend

  • Check file exists in a folder inside Directory in iPhone
  • Extract Residual Deviance from anova (glm) in R
  • System.Management.ManagementException: Not found
  • QT Creator has Error Locating OpenCV Sub-Headers Within Headers
  • How to exit “docker run” containers once the script those containers execute calls exit()
  • Job Scheduler inside of MVC3 Website
  • Python Tkinter entry widget won´t accept input
  • Can't install gmagick on Windows 7 XAMPP
  • Create unique ids for a group
  • How To Flush A Websites Cache?
  • Restore session after restart in JBoss
  • Cannot visualize images inside Xcode
  • How do I revert sys.stdout.close()?
  • Mod_rewrite: Force SSL on specific pages. Add www on none-secure pages
  • Finding regular expressions for languages otherwise described
  • Restart app on force kill
  • ASP Error 0223 - TypeLib Not Found, intermittent, resolved after IIS restart
  • Django Migrations fail during django initialization
  • Unable to gem install nokogiri
  • three.js WebVR example code works on threejs.org but not on my local server
  • Can't connect Entity Framework to local SQL Server Express
  • JSON Error when parsing “… has no method 'replace'”
  • Sympy: working with equalities manually
  • PostgreSQL 9.x - pg_read_binary_file & inserting files into bytea
  • sudo easy_install for SimpleITK not that easy
  • Efficient User-Agent Regex to find Safari in Python
  • Creating a Multidimensional, Associative Array in VBScript
  • Is it possible to get the word under the mouse cursor in a ``?
  • how to populate a SQLite database and use that database in phonegap?
  • Problem with Django using Apache2 (mod_wsgi), Occassionally is “unable to import from module” for no
  • How to skip require in ruby?
  • How to log in to an HTTPS website with Jsoup?
  • Creating a DropDownList
  • Authentication in Play! and RestEasy
  • How to match http request and response using Jersey ContainerRequestFilter and ContainerResponseFilt
  • PostgreSQL Query without WHERE only ORDER BY and LIMIT doesn't use index
  • Bug in WPF DataGrid
  • Busy indicator not showing up in wpf window [duplicate]
  • Python/Django TangoWithDjango Models and Databases
  • Net Present Value in Excel for Grouped Recurring CF