Cannot run pgreplicator over SSH [EUreg #12]

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Cc: pgreplicator(at)bp(dot)lnf(dot)it
Subject: Cannot run pgreplicator over SSH [EUreg #12]
Date: 2002-06-18 14:37:06
Message-ID: 20020618143706.GB15224@nic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 |

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-06-18 14:37:13 Re: number of registers of a table
Previous Message Tom Lane 2002-06-18 14:34:04 Re: [HACKERS] PERFORM effects FOUND patch (Was: I must be