Re: Postgres Help

Dear Sameer,

We are using postgresql 8.4 for both servers.

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.

****************************************************************