Re: BUG #6266: Create temp tables on Slave - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #6266: Create temp tables on Slave
Date
Msg-id 4EA67CE0.4010307@hogranch.com
Whole thread Raw
In response to Re: BUG #6266: Create temp tables on Slave  (Sally Nayer <sally.nayer@tedata.net>)
Responses Re: BUG #6266: Create temp tables on Slave  (Christopher Browne <cbbrowne@gmail.com>)
List pgsql-bugs
On 10/25/11 12:11 AM, Sally Nayer wrote:
> Is there commercial solution that uses the same concept of wal streaming and allows the Creation of temp tables on
slave

WAL files represent 'delta changes' between the state of the postgres
file system.  *anything* that changes database files on the slave side
would render the WAL files inherently unusable.

to do what you want would require using a fundamentally different
replication method, such as Slony or Bucardo.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-bugs by date:

Previous
From: "Roman Lytovchenko"
Date:
Subject: BUG #6268: multiple update with on cascade
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #6264: Superuser does not have inherent Replication permission