Re: Backup database remotely

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(at)spamfence(dot)net> wrote:
> 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°
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general