Skip to content
This repository has been archived by the owner on Sep 20, 2022. It is now read-only.

connection "paxos_join_group" not available #15

Closed
dotnwat opened this issue Jan 11, 2017 · 1 comment
Closed

connection "paxos_join_group" not available #15

dotnwat opened this issue Jan 11, 2017 · 1 comment

Comments

@dotnwat
Copy link

dotnwat commented Jan 11, 2017

I'm receiving the following error trying to setup pg_paxos on postgres 9.5.5. This is on a second node I'm trying to add to the group. Looks like this was filed before (#13) but that issue was closed without comment.

postgres=# select paxos_join_group('group0', 'host=10.10.1.1', 'host=10.10.1.2');
ERROR:  connection "paxos_join_group" not available
CONTEXT:  SQL statement "SELECT dblink_disconnect('paxos_join_group')"
PL/pgSQL function paxos_join_group(text,text,text) line 92 at PERFORM
@dotnwat
Copy link
Author

dotnwat commented Jan 11, 2017

This was caused by configuration issue. Needed to set listen_addresses and setup allowed connections in pg_hba.conf. It seems like the initial connection must have failed, but the error was masked and only saw the error for dblink_disconnect.

@dotnwat dotnwat closed this as completed Jan 11, 2017
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant