Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup database remotely - Mailing list pgsql-general

From Jasen Betts
Subject Re: Backup database remotely
Date
Msg-id jhpsum$v0o$1@reversiblemaps.ath.cx
Whole thread Raw
In response to Backup database remotely  (Fanbin Meng <fanbin.meng@kiltechcontrols.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Daniel Neugebauer
Date:
Subject: Re: MySQL search query is not executing in Postgres DB
Next
From: Jasen Betts
Date:
Subject: Re: Fwd: Re: Dynamic update of a date field