I am setting up a rubyrep configuration file with server information. No additional options. I tested if I can connect to both databases externally using PGAdmin.
When I check this, I see a connection spike on my monitoring graphs, so it enters there and looks at the initial table. I think * it connects to the second table, but somewhere along the line it breaks. The error I get is this
Exception caught: PG::Error: connection is closed: show search_path
I have the same schema for both databases. My rubyrep version is 1.20, my pg version is 0.14, and I tried 0.11 and 0.12, as in some question I saw some connection problems for some, but I still have a problem. I'm not sure what else to try.
Adding More Information
When I tried 2 local databases - there were no problems. Therefore, it seems that this is not a problem with my setup. When I changed the address to an external database, the one I want to copy from the above problem happened again.
When I tested this, I saw that it seemed like appropriate loads, however the data was not returned. I have limited access to the server, so I can’t check if there is any problem that occurs in the server logs, which actually causes Ruby rep to give me this error.
ruby database-replication
StanM
source share