Re: [GENERAL] Backup database remotely

2012-02-18 Thread Jasen Betts
On 2012-02-15, Andre Lopes 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 (or pg_dumpall)

Re: [GENERAL] Backup database remotely

2012-02-15 Thread Andreas Kretschmer
Andre Lopes 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.

Re: [GENERAL] Backup database remotely

2012-02-15 Thread Andre Lopes
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 wrote: > Fanbin Meng wrote: > >> I installed the PostgreSql9.0 in windows 7 with "one click installer". >> How can i backup another PostgreSql ser

Re: [GENERAL] Backup database remotely

2012-02-06 Thread Andreas Kretschmer
Fanbin Meng 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