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.klaver@aklaver.com