pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
LONDISTE:replication tables with different names but same structure
2+ messages / 2 participants
[nested] [flat]

* LONDISTE:replication tables with different names but same structure
@ 2011-05-12 23:23 Prabhjot Sheena <psheena@ql2.com>
  2011-08-15 22:16 ` Re: LONDISTE:replication tables with different names but same structure Dimitri Fontaine <dimitri@2ndQuadrant.fr>
  0 siblings, 1 reply; 2+ messages in thread

From: Prabhjot Sheena @ 2011-05-12 23:23 UTC (permalink / raw)
  To: pgsql-admin

Hello everyone
                      I have a situation here.i am using londiste. i want to
replicate  Table x ( a integer primary key, b integer) from database  test
                     to Table y( a integer primary key, b integer)
database test1.

what i know so far is that table name has to be same. but is there a way to
have different table names but same table structures.If anyone have the
answer plz help me


Thanks
Prabhjot Singh.
--

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: LONDISTE:replication tables with different names but same structure
  2011-05-12 23:23 LONDISTE:replication tables with different names but same structure Prabhjot Sheena <psheena@ql2.com>
@ 2011-08-15 22:16 ` Dimitri Fontaine <dimitri@2ndQuadrant.fr>
  0 siblings, 0 replies; 2+ messages in thread

From: Dimitri Fontaine @ 2011-08-15 22:16 UTC (permalink / raw)
  To: Prabhjot Sheena <psheena@ql2.com>; +Cc: pgsql-admin

Prabhjot Sheena <psheena@ql2.com> writes:
> what i know so far is that table name has to be same. but is there a way to
> have different table names but same table structures.If anyone have the
> answer plz help me

It's possible in skytools3, using handlers, that are special python
module to customize operations on subscribers.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2011-08-15 22:16 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-12 23:23 LONDISTE:replication tables with different names but same structure Prabhjot Sheena <psheena@ql2.com>
2011-08-15 22:16 ` Dimitri Fontaine <dimitri@2ndQuadrant.fr>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox