Mon Jan 24 09:38:35 PST 2011
- Previous message: [Slony1-general] /usr/bin/ld: skipping incompatible /usr/pgsql-9.0/lib//libpgport.a when searching for -lpgport
- Next message: [Slony1-general] Does Slony support replicating from one schema to another schema (different database, different schema name)?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi all: I am trying to use Slony for the first time - sorry if this is a newbie question... I am trying to replicating two of our JIRA databases into a data warehouse using Slony. Each instance has it's own "jira" database, and stores all tables and sequences in the "public" schema. In the data warehouse, I would like to replicate each instance to a schema in the same database. So something like: jira_host1:"jira":"public" -> dw_host1:"dw":"jira1" jira_host2:"jira":"public" -> dw_host2:"dw":"jira2" Can Slony do this and I am missing it in the documentation? Or is Slony not really designed to do this? If not designed to do this - does anybody have any suggestions on how to accomplish the above? Thanks for the help, all! -- Mark Mielke<mark at mielke.cc>
- Previous message: [Slony1-general] /usr/bin/ld: skipping incompatible /usr/pgsql-9.0/lib//libpgport.a when searching for -lpgport
- Next message: [Slony1-general] Does Slony support replicating from one schema to another schema (different database, different schema name)?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list