BUG #14435: PGAdmin 4 will not see the server
The following bug has been logged on the website:
Bug reference: 14435
Logged by: John Howitt
Email address: jmhowitt@mac.com
PostgreSQL version: 9.6.1
Operating system: OSX El Capitan
Description:
I installed PGAdmin 4 and i install Postgres 9.6.1. with homebrew. In the
postgres.conf i set list to port 5432 and i set listen_addresses to "*"
I can connect on the command line and i can connect with a tool called
Portico and with PGAdmin 3. However both versions of PGAdmin4 will not
connect and i just get a screen telling me "Failed to connect to the PGAmin
application server. Click here to try again."
If i run Postgres with the Mac Postgres.app which requires no installation
then PGA4 will connect.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
jmhowitt@mac.com writes:
I installed PGAdmin 4 and i install Postgres 9.6.1. with homebrew. In the
postgres.conf i set list to port 5432 and i set listen_addresses to "*"
I can connect on the command line and i can connect with a tool called
Portico and with PGAdmin 3. However both versions of PGAdmin4 will not
connect and i just get a screen telling me "Failed to connect to the PGAmin
application server. Click here to try again."
Does anything show up in the postmaster log when you do that?
I'm a bit suspicious that PGAdmin4 is trying to use an IPv6 definition of
"localhost" and you've only made provision for IPv4 in pg_hba.conf, or
something like that.
It's regrettable that PGAdmin4 isn't giving you more detail about the
failure, but you need to complain about that on the pgadmin lists,
not here --- this list is for server problems.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On 11/27/2016 1:32 AM, jmhowitt@mac.com wrote:
I installed PGAdmin 4 and i install Postgres 9.6.1. with homebrew. In the
postgres.conf i set list to port 5432 and i set listen_addresses to "*"
I can connect on the command line and i can connect with a tool called
Portico and with PGAdmin 3. However both versions of PGAdmin4 will not
connect and i just get a screen telling me "Failed to connect to the PGAmin
application server. Click here to try again."If i run Postgres with the Mac Postgres.app which requires no installation
then PGA4 will connect.
I believe pgadmin4 has a client-server architecture, where there is a
webserver component, and then the client is your web browser. that
error sounds like the client can't connect to the pgadmin webserver ?
anyways, pgsql bugs is for bugs in the core postgres database server,
pgadmin is a seperate project and has its own support channels.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs