Re: Backup database remotely

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Backup database remotely
Date: 2012-02-06 17:28:40
Message-ID: 20120206172840.GA16435@tux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fanbin Meng <fanbin(dot)meng(at)kiltechcontrols(dot)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°

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Misa Simic 2012-02-06 17:38:18 Re: How to create crosstab with 3 values in every crosstab column
Previous Message Andrew Dunstan 2012-02-06 17:18:19 Re: [GENERAL] pg_dump -s dumps data?!