| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Shaun McCloud <smccloud(at)geo-comm(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Union Question |
| Date: | 2010-12-06 19:39:23 |
| Message-ID: | AANLkTinidsyFGG8hwB+KGaGu5MMZWKRaia8R-w7MQPMs@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, Dec 3, 2010 at 8:58 AM, Plugge, Joe R. <JRPlugge(at)west(dot)com> wrote:
> Hello,
>
> I need to union three PostgreSQL tables and this won’t be a problem but the
> tables are on different servers. Basically, I have an administrative server
> that needs the tables viewable in a web administrator and three query
> servers that log the needed data locally. Is there a way I can do this
> without using Slony-I to replicate the data to the administrative server?
PL/Proxy might fit the bill also.
http://pgfoundry.org/projects/plproxy/
http://wiki.postgresql.org/wiki/PL/Proxy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Capobianco | 2010-12-07 21:07:13 | concatenate question |
| Previous Message | mike | 2010-12-06 16:21:31 | Re: The best option to insert data with primary id |