Multi server query

Started by Florent THOMASabout 14 years ago4 messagesgeneral
Jump to latest
#1Florent THOMAS
mailinglist@tdeo.fr

Hy all of you,

How do you query _multi servers_ and multi databases on postgresql?

Regards

#2Sergey Konoplev
gray.ru@gmail.com
In reply to: Florent THOMAS (#1)
Re: Multi server query

Hi,

On Mon, Mar 19, 2012 at 12:12 AM, Florent THOMAS <mailinglist@tdeo.fr> wrote:

How do you query multi servers and multi databases on postgresql?

Look at this http://wiki.postgresql.org/wiki/PL/Proxy

--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray.ru@gmail.com Skype: gray-hemp

#3John R Pierce
pierce@hogranch.com
In reply to: Florent THOMAS (#1)
Re: Multi server query

On 03/18/12 1:12 PM, Florent THOMAS wrote:

How do you query _multi servers_ and multi databases on postgresql?

other than plproxy, there's dblink, in the contrib collection. this
lets you query another database or server from within a SQL query

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

#4Florent THOMAS
mailinglist@tdeo.fr
In reply to: Sergey Konoplev (#2)
Re: Multi server query

Great thanks to all of you regards

Le 19/03/2012 09:58, Sergey Konoplev a �crit :

Show quoted text

Hi,

On Mon, Mar 19, 2012 at 12:12 AM, Florent THOMAS<mailinglist@tdeo.fr> wrote:

How do you query multi servers and multi databases on postgresql?

Look at this http://wiki.postgresql.org/wiki/PL/Proxy