Postgres Pro
Downloads
Home   >   mailing lists

Thread: Create Temp tables on SLave

Create Temp tables on SLave

From
Sally Nayer
Date:

Dear,

 

We need to create Temp Database on slave, we are using WAL streaming to replicate,

 

Is there any workaround?

Is there commercial solution to replicate that uses the same concept of Streaming WAL?

 

Thanks and Regards,

 

Sally Nayer        

IT Systems Senior Engineer

TE Data

TE Data, Building A11- B90, Smart Village

Cairo- Alex Desert Road, 28 Km

6th of October 12577, Egypt

T:  2 02 33 32 0733 |

F: 2 -02 33 32 0815| E: 2543
Visit: www.tedata.net

                                               

 

Re: Create Temp tables on SLave

From
Raghavendra
Date:
On Mon, Oct 24, 2011 at 7:22 PM, Sally Nayer <sally.nayer@tedata.net> wrote:

Dear,

 

We need to create Temp Database on slave, we are using WAL streaming to replicate,


Nothing is possible on Slave box in Streaming Replication.
 

 

Is there any workaround?

Is there commercial solution to replicate that uses the same concept of Streaming WAL?


I would say, you brief this question bit more. 

Am not sure whether there is a commercial product like Streaming Replication, however if you want some writes access on slave box then I believe you need to choose any Trigger Based Replication.

---
Regards,
Raghavendra
EnterpriseDB Corporation



Re: Create Temp tables on SLave

From
"Kevin Grittner"
Date:
Sally Nayer <sally.nayer@tedata.net> wrote:

> We need to create Temp Database on slave, we are using WAL
> streaming to replicate,

> Is there any workaround?

There are a number of alternatives:

http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

-Kevin