I'm trying to set up pgReplicator
<URL:http://pgreplicator.sourceforge.net/> over a SSH connection since
I plan to use it between remote places and I would not mind a little
privacy.
On the master machine, pgr runs:
eve:~ % telnet localhost 5430
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
Connection accepted
I create the SSH tunnel from the slave to the master:
vespucci:~ % ssh -L 2254:localhost:5430 eve sleep 60
It works:
vespucci:~ % telnet localhost 2254
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
But pgr disagrees:
vespucci:~ % ./pgr -sync registry
pgr - postgreSQL replicator
Version: 1.1.0
16:31:11 CHECK for connections whith hosts
+---------------+---------------------------------------------+----------+
|host |RPC_channel |RPC_state |
+---------------+---------------------------------------------+----------+
16:31:20 trying to connect to eve (port 2254)
16:31:23 trying to connect to eve (port 2254)
16:31:26 trying to connect to eve (port 2254)
|eve |Illegal value for -host "eve" |DOWN |