is their any other method to clone database,other then pgadmin and pgdump.. if is their option pls let me know..
On Wed, Dec 17, 2014 at 4:35 PM, Ramesh T <rameshparnandit...@gmail.com> wrote: > > 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 >>>> >>>
