Backup database remotely

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�

Hi all,

To do this backup remotely we need to open the 5434 port in the Firewall?

Best Regards,

On Mon, Feb 6, 2012 at 5:28 PM, Andreas Kretschmer
<akretschmer@spamfence.net> wrote:

Andre Lopes <lopes80andre@gmail.com> wrote:

Hi all,

To do this backup remotely we need to open the 5434 port in the Firewall?

If the database running on this port and if there are a firewall, so
yes.

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�

On 2012-02-15, Andre Lopes <lopes80andre@gmail.com> wrote:

Hi all,

To do this backup remotely we need to open the 5434 port in the Firewall?

Yes, you need a connection to the database, opening the firewall is
the simplest way to get that. (other ways include VPN and ssh
tunneling)

pg_dump -h <other_host> (or pg_dumpall)

--
⚂⚃ 100% natural