Still not working

[m99coder]

Hi Wesley @reediculous456 ,

thanks for your super quick reaction. After having merged your PR it does still not work on my machine. I don’t think the ports are the problem as the two Postgres instances have distinct hosts.

pgsubscriber_1  | 2021-03-16 18:56:32.386 GMT [78] ERROR:  could not connect to the postgresql server: could not connect to server: Connection refused
pgsubscriber_1  | 		Is the server running on host "pgsubscriber" (192.168.192.3) and accepting
pgsubscriber_1  | 		TCP/IP connections on port 5433?
pgsubscriber_1  |
pgsubscriber_1  | 2021-03-16 18:56:32.386 GMT [78] DETAIL:  dsn was:  host=pgsubscriber port=5433 dbname=pg_logical_replication_results user=replicate password=qwertz
pgsubscriber_1  | 2021-03-16 18:56:32.386 GMT [78] STATEMENT:  SELECT pglogical.create_subscription(
pgsubscriber_1  | 	  subscription_name := 'subscription',
pgsubscriber_1  | 	  replication_sets := array['hashes'],
pgsubscriber_1  | 	  provider_dsn := 'host=pgprovider port=5432 dbname=pg_logical_replication user=replicate password=qwertz'
pgsubscriber_1  | 	);
pgsubscriber_1  | psql:/docker-entrypoint-initdb.d/init.sql:29: ERROR:  could not connect to the postgresql server: could not connect to server: Connection refused
pgsubscriber_1  | 	Is the server running on host "pgsubscriber" (192.168.192.3) and accepting
pgsubscriber_1  | 	TCP/IP connections on port 5433?
pgsubscriber_1  |
pgsubscriber_1  | DETAIL:  dsn was:  host=pgsubscriber port=5433 dbname=pg_logical_replication_results user=replicate password=qwertz

My Docker setup is the following:

docker version
Client: Docker Engine - Community
 Cloud integration: 1.0.9
 Version:           20.10.5
 API version:       1.41
 Go version:        go1.13.15
 Git commit:        55c4c88
 Built:             Tue Mar  2 20:13:00 2021
 OS/Arch:           darwin/amd64
 Context:           default
 Experimental:      true

Server: Docker Engine - Community
 Engine:
  Version:          20.10.5
  API version:      1.41 (minimum version 1.12)
  Go version:       go1.13.15
  Git commit:       363e9a8
  Built:            Tue Mar  2 20:15:47 2021
  OS/Arch:          linux/amd64
  Experimental:     true
 containerd:
  Version:          1.4.3
  GitCommit:        269548fa27e0089a8b8278fc4fc781d7f65a939b
 runc:
  Version:          1.0.0-rc92
  GitCommit:        ff819c7e9184c13b7c2607fe6c30ae19403a7aff
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0

Does it work for you?

[reediculous456]

So I deleted the entire project and restarted it and it look like the issue is the execution order of the init.sql file. For some reason when then init.sql file runs, the container is still running on port 5432 but if you start the container back up after it crashes and manually add the subscription it works correctly

[m99coder]

Why is a different port crucial? These are different hosts that can have the same port. From what I see from the error message pglogical tries to connect to port 5433, but still fails.

[m99coder]

Restarting the containers is not showing an error as Postgres detects that there is a non-empty database directory and for that reason doesn’t execute the initial SQL queries from init.sql. It doesn’t try to create the nodes (the step that fails). Also a check of the replication table in the subscriber database shows that it’s empty and not containing the expected 1000 rows from the provider table.

[m99coder]

Could reproduce a working setup involving manual steps of creating the node and the subscription on subscriber side. Thanks for your help @reediculous456.