Groups > comp.databases.postgresql > #61

Re: posygresql and hot stand by

From	hitan <hitan@hunt.it>
Newsgroups	comp.databases.postgresql
Subject	Re: posygresql and hot stand by
Date	2011-03-29 13:35 +0200
Organization	C.U. srl News Server
Message-ID	<imsg64$1kt$1@tdi.cu.mi.it> (permalink)
References	<imq7da$ajk$1@tdi.cu.mi.it> <pan.2011.03.28.16.21.30@email.here.invalid>

Show all headers | View raw

Il 28/03/2011 18.21, Mladen Gogala ha scritto:
> On Mon, 28 Mar 2011 16:53:35 +0200, hitan wrote:
>
>> Hello, I have a problem with postgresql 9, you can exclude some tables
>> from the hot standby , because I have some tables that do not need to be
>> replicated
>>
>> Tanks
>
> Postgres 9 replication is not SQL based,you cannot exclude anything. What
> PostgreSQL gives you is an exact replica of your database cluster. If you
> want a schema based replication, try with Slony. It's easy to set up,
> supported by PgAdmin and very reliable, according to my experience.
>
>
>
thanks, but already use Slony, I wanted to replicate with native postgresql

Back to comp.databases.postgresql | Previous | Next | Find similar | Unroll thread

Thread

Re: posygresql and hot stand by hitan <hitan@hunt.it> - 2011-03-29 13:35 +0200

csiph-web