Thread: Backup database remotely

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.
Does anyone can help me or give suggestions?
Thanks
Fanbin

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

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