problem solved,
C:\Program Files\pgadmin\bin>pg_dump -U postgres host -p port -C -f c:\bb\db_1 db_2
then
to import i used psql
On Wed, Dec 17, 2014 at 10:44 AM, Ramesh T <rameshparnanditech@xxxxxxxxx> wrote:
Please let me know what happend inside ..?
On Wednesday, December 17, 2014, Ramesh T <rameshparnanditech@xxxxxxxxx> 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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
