| 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: | Whole Thread | Raw Message | 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      |
| 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 |