| 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: | Whole Thread | Raw Message | 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°
| 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?! |