Re: Backup database remotely

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Backup database remotely
Date: 2012-02-19 04:14:14
Message-ID: jhpsum$v0o$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2012-02-15, Andre Lopes <lopes80andre(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2012-02-19 07:31:13 Re: Easy form of "insert if it isn't already there"?
Previous Message Daniel Neugebauer 2012-02-18 23:50:16 Re: MySQL search query is not executing in Postgres DB