Cannot Connect to Network Project Library
Posted: Mon Oct 31, 2022 4:00 amHi all,
I just figured out a problem that I had connecting to a project library across our local network on Windows 10.
I was using the host name instead of the IP address, and it looks like a recent Windows Update has prioritized IPv6 over IPv4 name resolution.
Because of this, the PostgreSQL server was rejecting the connection.
I had to manually add the IPv6 ranges to pg_hba.conf.
Be careful if you do this since the Project Server can overwrite this file.
You can also just use the IPv4 address directly, but of course this can change from time to time.
Hope this helps someone out there!
I just figured out a problem that I had connecting to a project library across our local network on Windows 10.
I was using the host name instead of the IP address, and it looks like a recent Windows Update has prioritized IPv6 over IPv4 name resolution.
Because of this, the PostgreSQL server was rejecting the connection.
I had to manually add the IPv6 ranges to pg_hba.conf.
Be careful if you do this since the Project Server can overwrite this file.
You can also just use the IPv4 address directly, but of course this can change from time to time.
Hope this helps someone out there!