Databases not Syncing

[Jack Elendil Lagare]

When I run the scan command, it ends without any output at all. I'm trying to replicate two databases in the same host. I tried doing this with two test databases having only one table with two columns. It worked.

I have attached the configuration code below:

RR::Initializer::run do |config|
    config.left = {
    :adapter  => 'postgresql', # or 'mysql'
    :database => '*******',
    :username => 'rubyrep',
    :password => 'rubyrep',
    :host     => '****',
    :encoding => 'utf8',
    :port => '5432'
 }
 config.right = {
    :adapter  => 'postgresql',
    :database => '*******_2',
     :username => 'rubyrep',
     :password => 'rubyrep',
     :host     => '****',
     :encoding => 'utf8',
     :port=>'5432'
 }
 config.options[:sync_conflict_handling] = :left_wins
 config.options[:auto_key_limit] = 3
 config.options[:logged_replication_events] = [
:all_changes
 ]
 config.include_tables /./ # regexp matching all tables in the database'
 config.left[:logger] = "/var/log/rubyrep/rubyrep_left_sql.log"
 config.right[:logger] = "/var/log/rubyrep/rubyrep_right_sql.log"
end

[Shajimon Abraham]

Hi jack

your single table resides in what schema. if not in public use :schema_search_path=>'schema name here' , in your config. hope this will help

shajimon

--
You received this message because you are subscribed to the Google Groups "rubyrep" group.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyrep/-/CskKUSLHcgwJ.
To post to this group, send email to rub...@googlegroups.com.
To unsubscribe from this group, send email to rubyrep+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyrep?hl=en.

[Jack Elendil Lagare]

Hmmm. For some reason I removed that. 

The error is now a table cannot be found in the schame. I have :schema_search_path => 'schema1,schema2' . Is this the correct way of defining two schema search paths?

[Shajimon Abraham]

hi jack

 That is what the help says. Frankly I could never get result when used more than one schema. If you manage it kindly share how you got it

shajimon

To view this discussion on the web visit https://groups.google.com/d/msg/rubyrep/-/5tFL0QoqYcQJ.