Skip site navigation (1) Skip section navigation (2)

Re: BUG #6266: Create temp tables on Slave

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6266: Create temp tables on Slave
Date: 2011-10-25 09:09:52
Message-ID: 4EA67CE0.4010307@hogranch.com (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-bugs by date

Next:From: Paul StapersmaDate: 2011-10-25 09:51:32
Subject: BUG #6269: Anomaly detection
Previous:From: Roman LytovchenkoDate: 2011-10-25 08:58:55
Subject: BUG #6268: multiple update with on cascade

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group