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 <rameshparnandit...@gmail.com> wrote: > > Please let me know what happend inside ..? > > > On Wednesday, December 17, 2014, Ramesh T <rameshparnandit...@gmail.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.kla...@aklaver.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.kla...@aklaver.com >>> >>
