Re: pg_dump

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