Re: Postgres Help

On Mon, 18 Apr 2016 23:54 PARLIKAR, Sandip, <sparlikar(at)forbesmarshall(dot)com>
wrote:

> Dear Sameer,
>
> We are using postgresql 8.4 for both servers.
>

You should consider upgrading. You are loosing on lot of great features and
fixes.

With newer versions of Postgres,fdw works better than dblink and is a more
generic framework.

> Kindly refer attached server architecture of postgres servers.
>
> We want to push data from sites to central server.
>
> --
> Regards,
> Sandip Parlikar
>
> On Mon, Apr 18, 2016 at 9:04 PM, Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
> wrote:
>
>>
>>
>> On Mon, 18 Apr 2016 08:26 PARLIKAR, Sandip, <sparlikar(at)forbesmarshall(dot)com>
>> wrote:
>>
>>> Dear Team,
>>>
>>> I want to insert data from client server to central server (remote)
>>> using pgadmin III in postgresql.
>>>
>>>
>>> e.g.
>>>
>>> SELECT dblink_exec('host=remote central server IP port=5432 dbname=test
>>> user=test password=test',
>>>
>>> 'insert into t_table1' from dblink('host=client Server port=5432
>>> dbname=test1 user=test1 password=test1 ','SELECT * FROM t_table2
>>>
>>>
>>> when we execute above query it is taking central server table only and
>>> not considering table2 (client server)
>>>
>>
>> What is the version of Postgres that you are using?
>> On central server and the federated server?
>>
>> A rough diagram of setup would be helpful.
>>
>>
>>> Kindly help.
>>>
>>>
>>> I want to execute above query for multiple sites.
>>>
>>> --
>>> Regards,
>>> Sandip Parlikar
>>>
>>> --
>> --
>> Best Regards
>> Sameer Kumar | DB Solution Architect
>> *ASHNIK PTE. LTD.*
>>
>> 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
>>
>> T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
>>
>
>
> *Download SteamHUB - the smart app for steam users. This app is currently
> available for Android phones – click here to download
> now.http://www.forbesmarshall.com/mobileApp/steamHUB/
> <http://www.forbesmarshall.com/mobileApp/steamHUB/>*
>
> DISCLAIMER:This email (and any attachment) is confidential, may be
> legally privileged and is intended solely for the use of the individual or
> entity to whom it is addressed. If you are not the intended recipient
> please do not disclose, disseminate, distribute, copy or take any action in
> reliance on it. If you received this message in error please tell us by
> reply (or telephone the sender) and delete all copies on your system.
> Although we have taken reasonable precautions to ensure no viruses are
> present in this email, we cannot accept responsibility for any loss or
> damage arising from the use of this email or attachments and would advise
> that you carry out your own virus scan before opening any attachment.
>
> ****************************************************************
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533

T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com