Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4EF5A2E156A for ; Thu, 10 Jan 2008 11:20:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 00502-07 for ; Thu, 10 Jan 2008 11:19:53 -0400 (AST) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.226]) by postgresql.org (Postfix) with ESMTP id DA8E32E00F3 for ; Thu, 10 Jan 2008 11:20:01 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id r21so406650wxc.28 for ; Thu, 10 Jan 2008 07:20:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=8hhSYo5aCMWOXQdacP5D62PlJunNm9WaRX8Jos9L99k=; b=YFlDC9XN6ui5PsUPwyacD+m6tluT6Tyu7Npj0atUZjbtT0sXIwfISTjE+es+A2zgGMl2t9y0EXFdfd0tD8Un63KX6CjMDnVNFokwCa7Rf1aquuKteV9jELqD+/FnzsWzUn8K2lFK9Ayjke6xLK8J6nfiUmm9pvsjLYKRdGqyJks= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=suTiTayAqfkbn8IQXpwvn9DwPsKA1cSsU85Z+CUREcn6jnEcjHlgpk9TsjP3oHoGAqOqVLb55F4s9Jb1vyr+V9e2QUDmk/HLQIo/0Y5+so0arz6wDPky6gBg+9xOPSm3oBvfAvDEX5IAUpStAcOzADzY3K7Xrm+75SbyiPbA91E= Received: by 10.114.135.1 with SMTP id i1mr2387853wad.88.1199978398783; Thu, 10 Jan 2008 07:19:58 -0800 (PST) Received: by 10.114.131.4 with HTTP; Thu, 10 Jan 2008 07:19:58 -0800 (PST) Message-ID: Date: Thu, 10 Jan 2008 09:19:58 -0600 From: "Scott Marlowe" To: nalini Subject: Re: Postgres replication Cc: pgsql-admin@postgresql.org In-Reply-To: <46b8ed581b47692a.478611ce@nic.in> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46b8ed581b47692a.478611ce@nic.in> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/105 X-Sequence-Number: 27879 On Jan 10, 2008 1:38 AM, nalini wrote: > Dear All > > I have a application running at various locations with backend as postgres > Slony is configured at all locations for replication at local site anda > central server where each site has its own database instance. > > Now we wish to merge data collected from all the sites into one database > instance to provide consolidated view > > database schema is same at all the places > However as the application is still under development the schema maychange. > however the change will happen at all the locations. I would replicate each one to a different schema on the same server and then use views to consolidate the data into what appears to be one set. To make everything unique, you could prepend a unique id to each identifier based on the schema it came from.