Is the server running on host "." (54.) and accepting
#SQLPRO FOR POSTGRES ROLE DOES NOT EXIST PRO#
Here's the command I'm trying to use to connect: psql -host=. \Īnd this is the result I'm getting when trying to connect from a Yosemite MacBook Pro (note, it's resolving to a 54.* ip address): psql: could not connect to server: Operation timed out Here're the security group settings, note it's wide open (affirmed in the RDS settings above by the green "authorized" hint next to the endpoint): Here're the database settings, note that it's marked as Publicly Accessible: I must be missing something very straightforward - but I'm pretty lost on this. It uses the default security group, which is open for port 5432. (stdlib) gen_server.erl:342: :gen_server.I created a basic test PostgreSQL RDS instance in a VPC that has a single public subnet and that should be available to connect over the public internet. ** (Mix) Could not start application explorer: (:normal, ) returned an error: shutdown: failed to start child: (stdlib) gen_server.erl:342: :gen_server.init_it/6 (stdlib) gen_server.erl:374: :gen_server.init_it/2 (explorer) lib/explorer/counters/average_block_time.ex:46: /1 (explorer) lib/explorer/counters/average_block_time.ex:84: _timestamps/0 (ecto) lib/ecto/repo/queryable.ex:153: /4 (ecto_sql) lib/ecto/adapters/sql.ex:621: _sql_call_error/1 See DBConnection.start_link/2 for more information You can configure how long requests wait in the queue using :queue_target and :queue_interval. ** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 2941ms. T14:41:22.076 Application explorer exited: (:normal, ) returned an error: shutdown: failed to start child: T14:41:22.044 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:21.718 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:21.670 application=tzdata Tzdata has updated the release from 2019a to 2019c
T14:41:21.624 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:21.618 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:21.235 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:21.222 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:21.115 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:20.891 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist
T14:41:20.494 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:20.322 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:20.294 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:20.164 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist Release file on server was last modified Wed, 19:35:17 GMT. T14:41:20.075 application=tzdata tzdata release in place is from a file last modified Tue, 05:40:14 GMT.
T14:41:19.115 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist T14:41:19.110 application=db_connection Postgrex.Protocol (#PID) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) role "postgres" does not exist
0 kommentar(er)
