| From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
|---|---|
| To: | Sally Nayer <sally(dot)nayer(at)tedata(dot)net> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Create Temp tables on SLave |
| Date: | 2011-10-25 12:54:16 |
| Message-ID: | CA+h6Ahg7xBDOH8xoMWw6oQ02Mh0Ns7dUTFh-EDx5OvvkmFa0kQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Oct 24, 2011 at 7:22 PM, Sally Nayer <sally(dot)nayer(at)tedata(dot)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
Blog: http://raghavt.blogspot.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-10-25 14:41:53 | Re: Create Temp tables on SLave |
| Previous Message | Craig Ringer | 2011-10-25 03:45:39 | Re: Dumping data using pg_dump after chrooting to a different partition |