Re: Postgres Help

Dear Sameer,

Thank you for help.

Kindly suggest the version and fdw process so that it will help us to set
the architecture.

--
Regards,
Sandip Parlikar

On Wed, Apr 20, 2016 at 3:05 AM, Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
wrote:

>
>
> 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
>

--

*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.

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