Postgres listener hardcoded to bind on localhost only?

[tetious]

ArcadeDB Version: 21.10.2-SNAPSHOT (build ae608bf/1633588344745/main)

OS: Docker

Expected behavior

The Postgres listener starts on 0.0.0.0, or is at least configurable as such.

Actual behavior

From looking at the code, It seems like it is hardcoded to bind to localhost, which is not ideal for using outside the container itself.

The log message seems to confirm this.

[PostgresNetworkListener] <ArcadeDB_0> Listening for replication connections on 127.0.0.1:5432 (protocol v.-1)

The example in the docs implies it will work, but it doesn't expose 5432, so I'm not sure what's going on there. I suspect a typo. 😄

docker run --rm -p 2480:2480 -p 2424:2424 --env arcadedb.server.rootPassword=playwithdata --env arcadedb.server.plugins="Postgres:com.arcadedb.postgres.PostgresProtocolPlugin" arcadedata/arcadedb:latest

[lvca]

This is definitely a bug. The test and the docs are based on the non-docker version.

[lvca]

Implemented. Now by default the tcp/ip socket listen to 0.0.0.0 but it's configurable with 2 new settings:

• POSTGRES_PORT("arcadedb.postgres.port", "TCP/IP port number used for incoming connections for Postgres plugin. Default is 5432", Integer.class, 5432)
• POSTGRES_HOST("arcadedb.postgres.host", "TCP/IP host name used for incoming connections for Postgres plugin. Default is '0.0.0.0'", String.class, "0.0.0.0")

Example: bin/server.sh -Darcadedb.postgres.host=127.0.0.1 ...