Discussion:
[ADMIN] Create Temp tables on SLave
(too old to reply)
Raghavendra
2011-10-25 12:54:16 UTC
Permalink
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
Blog: http://raghavt.blogspot.com/
Kevin Grittner
2011-10-25 14:41:53 UTC
Permalink
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
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...