Re: [GENERAL] replication from multiple "master" servers to a single read-only slave

2010-01-12 Thread Omar Mehmood
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

[GENERAL] transaction logging in the form of SQL statements

2010-01-11 Thread Omar Mehmood
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

Re: [GENERAL] replication from multiple "master" servers to a single read-only slave

2010-01-11 Thread Omar Mehmood
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

[GENERAL] replication from multiple "master" servers to a single read-only slave

2010-01-11 Thread Omar Mehmood
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