Re: Remote Backup (pg_dump_all) Windows/Linux.

On Wed, Jan 8, 2014 at 9:15 AM, Renato Forti <re(dot)tf(at)acm(dot)org> wrote:
> I have one question about backup (pg_dump_all).

pg_dumpall

> I have one pg running on linux (x64), and I want take one backup of it. But
> from a windows machine (x32) . A remote backup!
>
> I can do this? The pg need be same version and bitness on windows and linux?
> Any other advise?

This is an SQL dump so it does not need to be on the same
architecture. The only recommendation is the same or later version.

> What command option (pg_dump_all) I can use to do this?

Here you will find the pg_dumpall docs

http://www.postgresql.org/docs/current/interactive/app-pg-dumpall.html

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com