Re: Postgres Help

On Wed, Apr 20, 2016 at 5:20 PM PARLIKAR, Sandip <
sparlikar(at)forbesmarshall(dot)com> wrote:

> Dear Sameer,
>
> Thank you for help.
>
> Kindly suggest the version and fdw process so that it will help us to set
> the architecture.
>

Is this a testing or QA environment? It would be nice if you can add more
details about the use-case/problem statement here.

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