Re: Backup database remotely - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Backup database remotely
Date
Msg-id 20120206172840.GA16435@tux
Whole thread Raw
In response to Backup database remotely  (Fanbin Meng <fanbin.meng@kiltechcontrols.com>)
Responses Re: Backup database remotely
List pgsql-general
Fanbin Meng <fanbin.meng@kiltechcontrols.com> wrote:

> I installed the PostgreSql9.0 in windows 7 with "one click installer".
> How can i backup another PostgreSql server database remotely  via an internet
> connection .
> I trid "add a connection to a server", but it did not work.

Don't know waht you mean with 'add a connection to a server'. You should
use something like:

pg_dump -h <other_host> (or pg_dumpall)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Richard Sickler
Date:
Subject: Re: windows 2008 scheduled task problem
Next
From: Misa Simic
Date:
Subject: Re: Triggering a function on table overwrite