Re: Up-to-date reports database

From: Herouth Maoz <herouth(at)unicell(dot)co(dot)il>
To: cernst(at)zvelo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Up-to-date reports database
Date: 2012-05-23 15:12:45
Message-ID: 2E74812C-8B5D-4E5A-94D3-1DAC742C9C1D@unicell.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 23/05/2012, at 17:20, Chris Ernst wrote:

> I would have a look at slony. It is a trigger based replication system
> that allows you to replicate only the tables you define and you can have
> different indexing on the slave. The only requirement is that each
> table you want to replicate has the same primary key or unique
> constraint on the master and slave. Other than that, you can index the
> tables on the slave however you want.

Thanks for the pointer. I will read up about it.

Herouth

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bartosz Dmytrak 2012-05-23 15:54:00 Re: Up-to-date reports database
Previous Message Welty, Richard 2012-05-23 14:50:07 Re: Migrating from 8.2 to 9.1 : invalid port number