Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump - Mailing list pgsql-general

From Ramesh T
Subject Re: pg_dump
Date
Msg-id CAK8Zd=vWY8CQmz=mQFiv6_F-6tW0PtoBnVnVTRL7m0XghJCiAw@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view

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..?

On Tue, Dec 16, 2014 at 9:25 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/16/2014 07:52 AM, Ramesh T wrote:
CCing list.

1.
-bash-4.1$  pg_dump -C -Fp -f C:\backup\db_1.dump  db_2

how to export and where i can save export file

 Per my previous post:


That would depend on where your Postgres server is relative to the c:\ drive.






--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Ramesh T
Date:
Subject: pg_dump
Next
From: harpagornis
Date:
Subject: Re: SSL Certificates in Windows 7 & Postgres 9.3