Re: pg_dump

Please let me know what happend inside ..?

On Wednesday, December 17, 2014, Ramesh T <rameshparnanditech(at)gmail(dot)com>
wrote:

>
> I'm installed pgadmin 3 on windows I'm trying to connect server.the server
> is on Linux.now I'm trying pgdump from windows from using putty connected
> to Linux Postgres server..also last mail I sent trying from windows local
> c:\... :)
> On Wednesday, December 17, 2014, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <javascript:_e(%7B%7D,'cvml','adrian(dot)klaver(at)aklaver(dot)com');>> wrote:
>
>> On 12/16/2014 08:17 AM, Ramesh T wrote:
>>
>>>
>>> C:\Program Files\pgAdmin III\1.14>pg_dump -U postgres -p 5432 -C -f
>>> c:\backup\db_2.dump db_1;
>>> pg_dump: [archiver (db)] connection to database "db_1;"
>>>
>>> failed: coul
>>> d not connect to server: Connection refused (0x0000274D/10061)
>>> Is the server running on host "localhost" (::1) and accepting
>>> TCP/IP connections on port 5432?
>>> could not connect to server: Connection refused (0x0000274D/10061)
>>> Is the server running on host "localhost" (127.0.0.1) and
>>>
>>> accepting
>>> TCP/IP connections on port 5432?
>>>
>>>
>>> is it right excution process ,if it is yes 5432..?
>>>
>>
>> Previously you where using PuTTY to log in to the machine with the
>> Postgres server, so I assume it is not running on the Windows machine. If
>> that is the case doing the above is bound to fail. What the error is
>> telling you is that pg_dump cannot find a Postgres instance listening where
>> you told it to go. Bottom line is you need to be more accurate in what you
>> are doing.
>>
>> So:
>>
>> 1) Back to my first post; "That would depend on where your Postgres
>> server is relative to the c\ drive."
>>
>> What machine is the Postgres server located on?
>>
>> What machine are you trying to connect from?
>>
>> Everything you posted relates to the above. These questions need to be
>> answered before we can go any further.
>>
>>
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>