shua Tolley wrote:
> From: Joshua Tolley
> Subject: Re: [GENERAL] replication from multiple "master" servers to a single
> read-only slave
> To: "Omar Mehmood"
> Cc: "Ben Chobot" , pgsql-general@postgresql.org
> Date: Tuesday, January 12, 2010, 2
Is there any way to enable transaction logging in the format of SQL statements
for committed transactions only ? In other words, a way to log all the SQL
statements (including START TRANSACTION and COMMIT statements) for all
committed mod type statements (INSERT UPDATE DELETE etc).
Thanks,
Oma
aster" servers to a single
> read-only slave
> To: "Omar Mehmood"
> Date: Monday, January 11, 2010, 6:58 PM
> I'm pretty sure you can do this with
> Bucardo, and I *think* you can do it via Slony, if you're
> willing to use seperate schemas for each mast
I'm wondering if it's possible to have a setup with multiple "master" servers
replicating to a single slave. I can guarantee that each server will generate
unique PK values for all tables and all the data is partitioned (logically by
server) across the servers. I would simply like to have a re