Re: pg_dump

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 <rameshparnanditech(at)gmail(dot)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 <rameshparnanditech(at)gmail(dot)com>
> wrote:
>>
>> Please let me know what happend inside ..?
>>
>>
>> On Wednesday, December 17, 2014, Ramesh T <rameshparnanditech(at)gmail(dot)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(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
>>>>
>>>