Обсуждение: Create Temp tables on SLave

Поиск
Список
Период
Сортировка

Create Temp tables on SLave

От
Sally Nayer
Дата:

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

От
Raghavendra
Дата:
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

От
"Kevin Grittner"
Дата:
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