CODEWITHSUNDEEP
rubypostgresqlreplication
adamo
adamo

Reputation: 4052

rubyrep Exception caught: PG::ConnectionBad: connection is closed: show search_path

I am trying to use rubyrep to just scan between two databases and am getting the following error:

Exception caught: PG::ConnectionBad: connection is closed: show search_path

I have verified that from the command line (psql) I can connect and select from the databases. Any ideas?

Upvotes: 1

Views: 603

Answers (1)

adamo
adamo

Reputation: 4052

Here is what I have found out in order to make rubyrep work:

  • The stock gem that comes with gem install rubyrep does not seem to work when in combnation with the latest pg gem. I have not tried using older versions of pg, because:

  • Using this fork of rubyrep seems to work. You need to clone it with git and then run a gem build rubyrep.gemspec in order to build the gem locally. Then, you run gem install ./rubyrep-XXXXXX.gem and you are done.

I tried the above gem with both ruby 2.1.5 and jruby. It was equally painfully slow.

Upvotes: 2

Related Questions