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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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