Cannot run pgreplicator over SSH [EUreg #12]

Started by Stephane Bortzmeyeralmost 24 years ago1 messagesgeneral
Jump to latest
#1Stephane Bortzmeyer
bortzmeyer@nic.fr

I'm trying to set up pgReplicator
<URL:http://pgreplicator.sourceforge.net/&gt; 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      |