Hello,
I have a problem with Postgresql (8.3) replication.
Publication server starting correctly, buy when I've create subscription (subscription server starting correctly) I've an error:
org.dbreplicator.replication.RepException:
Error subscribing subscription 'sub1':'invalid authority:rmi://aristo_cer1:3001/aristo_cer1_3001.
Publication server was starting on aristo_cer1 on 3001 port.
Regards
Tomek
| Attachment | Size |
|---|---|
| error.JPG | 32.08 KB |
Re: Postgesql replication problem
java.rmi.Naming has problems with hostnames that contain the '_'(underscore) character after java version 1.3 or so, if I recall. It was around then that they updated it to be more standards compliant, and hostnames with _'s in them are definitely not standard, so I expect that it's that character in your hostname which is causing the problem. Java can't figure out the hostname/port of your rmi registry and is bailing, albeit without a clear explanation of why. If you must have a separator in your machine's hostname, try using a '-'(dash) instead, and do let me know if that fixes the problem. If it doesn't I'll dig into it some more.
Thanks for your support
Thanks for your support ...
I made as you wrote - changed host name (drop _ character) and It's look like connecting is OK (previous message is not shown), but now I've replication error (Can not find xml file at specified path - see assign file).
What the xml file do you mind ?
Regards,
Tomek
I've seen this error before,
I've seen this error before, and it means that the xml file is failing to transfer. All replication operations are transferred between hosts using zip'd xml files, and this is the error you get if a transfer fails for some reason. If you un-comment the DEBUG line in the log4j.properties file and send along the output (from both publisher and subscriber), we should be able to figure it out in short order.
The problem was resolved
The problem was resolved .... :)
It's my inadvertence.
In the PubServer.bat and SubServer.bat file at server start line -Djava.rmi.server.hostname I've the same host name (in publisher and subscriber).
When I changed the hostname as real host name (different on publisher and subscriber) - subscribtion was creating OK.
Thanks,
Tomek