pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMerging two databases
3+ messages / 3 participants
[nested] [flat]
* Merging two databases
@ 2012-06-12 10:23 Lukasz Brodziak <lukasz.brodziak@gmail.com>
2012-06-13 02:08 ` Re: Merging two databases Craig Ringer <ringerc@ringerc.id.au>
2012-06-14 18:34 ` Re: Merging two databases Amador Alvarez <aalvarez@d2.com>
0 siblings, 2 replies; 3+ messages in thread
From: Lukasz Brodziak @ 2012-06-12 10:23 UTC (permalink / raw)
To: pgsql-admin
Hi there,
Is there a way of merging two databases in postgresql in the way of
differential replication? The thing is that we have two DBs with same
schemas and we want to merge the data within them into one single
replica. Are there any tools/ways of doing this? Of course when the
merged db is created it will be only updated/inserted with new data
from each of source DBs.
--
Łukasz Brodziak
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Merging two databases
2012-06-12 10:23 Merging two databases Lukasz Brodziak <lukasz.brodziak@gmail.com>
@ 2012-06-13 02:08 ` Craig Ringer <ringerc@ringerc.id.au>
1 sibling, 0 replies; 3+ messages in thread
From: Craig Ringer @ 2012-06-13 02:08 UTC (permalink / raw)
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>; +Cc: pgsql-admin
On 06/12/2012 06:23 PM, Lukasz Brodziak wrote:
> Hi there,
>
> Is there a way of merging two databases in postgresql in the way of
> differential replication? The thing is that we have two DBs with same
> schemas and we want to merge the data within them into one single
> replica. Are there any tools/ways of doing this?
I think you'll want Bucardo or Slony-I for this. You certainly can't do
it with the built-in replication.
--
Craig Ringer
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Merging two databases
2012-06-12 10:23 Merging two databases Lukasz Brodziak <lukasz.brodziak@gmail.com>
@ 2012-06-14 18:34 ` Amador Alvarez <aalvarez@d2.com>
1 sibling, 0 replies; 3+ messages in thread
From: Amador Alvarez @ 2012-06-14 18:34 UTC (permalink / raw)
To: pgsql-admin
Hi,
Obviously it will always depends on the constraints in your schema, but
why do not dump the databases out and import it into a single one
properly? Once you get the new database, it should be easy to catch up
with the 2 databases before the switching (with statements like
insert/update into Newdb tables ...(select from Olddb tables)).
It is up to you, this is to avoid replication settings, however using
replication could be a good thing for future replication experiences.
A.A.
On 06/12/2012 03:23 AM, Lukasz Brodziak wrote:
> Hi there,
>
> Is there a way of merging two databases in postgresql in the way of
> differential replication? The thing is that we have two DBs with same
> schemas and we want to merge the data within them into one single
> replica. Are there any tools/ways of doing this? Of course when the
> merged db is created it will be only updated/inserted with new data
> from each of source DBs.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-06-14 18:34 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-06-12 10:23 Merging two databases Lukasz Brodziak <lukasz.brodziak@gmail.com>
2012-06-13 02:08 ` Craig Ringer <ringerc@ringerc.id.au>
2012-06-14 18:34 ` Amador Alvarez <aalvarez@d2.com>
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