MIME-version: 1.0
Content-type: multipart/alternative;
	boundary="Boundary_(ID_wjCLVVL3pdWNtYxplrjNCw)"
From: nalini <nalini@nic.in>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Message-id: <57ba119935d4d190.47879bd5@nic.in>
Date: Fri, 11 Jan 2008 16:39:49 +0500
Content-language: en
Subject: Re: Postgres replication
In-reply-to: <dcc563d10801100719q67aa0432l652d74661bbae5e8@mail.gmail.com>
References: <46b8ed581b47692a.478611ce@nic.in>
	<dcc563d10801100719q67aa0432l652d74661bbae5e8@mail.gmail.com>

This is a multi-part message in MIME format.


--Boundary_(ID_wjCLVVL3pdWNtYxplrjNCw)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: quoted-printable
Content-disposition: inline

Thanks for the suggestion=2E I would still like to know whether we have =
any tools available in open source domain for the same=2E Handling views=
 may become difficult due to size and complexity of the database  =


----- Original Message -----
From=3A Scott Marlowe =3Cscott=2Emarlowe=40gmail=2Ecom=3E
Date=3A Thursday=2C January 10=2C 2008 8=3A48 pm
Subject=3A Re=3A =5BADMIN=5D Postgres replication
To=3A nalini =3Cnalini=40nic=2Ein=3E
Cc=3A pgsql-admin=40postgresql=2Eorg

=3E On Jan 10=2C 2008 1=3A38 AM=2C nalini =3Cnalini=40nic=2Ein=3E wrote=3A=

=3E =3E Dear All
=3E =3E
=3E =3E I have a application running at various locations with backend =

=3E as postgres
=3E =3E Slony is configured at all locations for replication at local =

=3E site anda
=3E =3E central server where each site has its own database instance=2E
=3E =3E
=3E =3E Now we wish to merge data collected from all the sites into =

=3E one database
=3E =3E instance to provide consolidated view
=3E =3E
=3E =3E database schema is same at all the places
=3E =3E However as the application is still under development the =

=3E schema maychange=2E
=3E =3E however the change will happen at all the locations=2E
=3E =

=3E I would replicate each one to a different schema on the same server
=3E and then use views to consolidate the data into what appears to =

=3E be one
=3E set=2E=A0 To make everything unique=2C you could prepend a unique =

=3E id to each
=3E identifier based on the schema it came from=2E
=3E =

=3E ---------------------------(end of broadcast)--------------------
=3E -------
=3E TIP 6=3A explain analyze is your friend

Nalini S=2E Nautiyal


--Boundary_(ID_wjCLVVL3pdWNtYxplrjNCw)
Content-type: text/html; charset=us-ascii
Content-transfer-encoding: quoted-printable
Content-disposition: inline

Thanks for the suggestion=2E I would still like to know whether we have =
any tools available in open source domain for the same=2E Handling views=
 may become difficult due to size and complexity of the database  =3Cbr=3E=
=3Cbr=3E=3Cbr=3E=3Cbr=3E=3Cbr=3E----- Original Message -----=3Cbr=3EFrom=
=3A Scott Marlowe =26lt=3Bscott=2Emarlowe=40gmail=2Ecom=26gt=3B=3Cbr=3ED=
ate=3A Thursday=2C January 10=2C 2008 8=3A48 pm=3Cbr=3ESubject=3A Re=3A =
=5BADMIN=5D Postgres replication=3Cbr=3ETo=3A nalini =26lt=3Bnalini=40ni=
c=2Ein=26gt=3B=3Cbr=3ECc=3A pgsql-admin=40postgresql=2Eorg=3Cbr=3E=3Cbr=3E=
=26gt=3B On Jan 10=2C 2008 1=3A38 AM=2C nalini =26lt=3Bnalini=40nic=2Ein=
=26gt=3B wrote=3A=3Cbr=3E=26gt=3B =26gt=3B Dear All=3Cbr=3E=26gt=3B =26g=
t=3B=3Cbr=3E=26gt=3B =26gt=3B I have a application running at various lo=
cations with backend =3Cbr=3E=26gt=3B as postgres=3Cbr=3E=26gt=3B =26gt=3B=
 Slony is configured at all locations for replication at local =3Cbr=3E=26=
gt=3B site anda=3Cbr=3E=26gt=3B =26gt=3B central server where each site =
has its own database instance=2E=3Cbr=3E=26gt=3B =26gt=3B=3Cbr=3E=26gt=3B=
 =26gt=3B Now we wish to merge data collected from all the sites into =3C=
br=3E=26gt=3B one database=3Cbr=3E=26gt=3B =26gt=3B instance to provide =
consolidated view=3Cbr=3E=26gt=3B =26gt=3B=3Cbr=3E=26gt=3B =26gt=3B data=
base schema is same at all the places=3Cbr=3E=26gt=3B =26gt=3B However a=
s the application is still under development the =3Cbr=3E=26gt=3B schema=
 maychange=2E=3Cbr=3E=26gt=3B =26gt=3B however the change will happen at=
 all the locations=2E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B I would replicate=
 each one to a different schema on the same server=3Cbr=3E=26gt=3B and t=
hen use views to consolidate the data into what appears to =3Cbr=3E=26gt=
=3B be one=3Cbr=3E=26gt=3B set=2E=26nbsp=3B To make everything unique=2C=
 you could prepend a unique =3Cbr=3E=26gt=3B id to each=3Cbr=3E=26gt=3B =
identifier based on the schema it came from=2E=3Cbr=3E=26gt=3B =3Cbr=3E=26=
gt=3B ---------------------------(end of broadcast)--------------------=3C=
br=3E=26gt=3B -------=3Cbr=3E=26gt=3B TIP 6=3A explain analyze is your f=
riend=3Cbr=3E=3Cbr=3ENalini S=2E Nautiyal=3Cbr=3E

--Boundary_(ID_wjCLVVL3pdWNtYxplrjNCw)--