Re: Remote Backup (pg_dump_all) Windows/Linux. - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: Remote Backup (pg_dump_all) Windows/Linux.
Date
Msg-id CAL_0b1uff=6oy7W9jD3cwQzGLNuuoEtU327iqVa8VQ0QsGfUxQ@mail.gmail.com
Whole thread Raw
In response to Remote Backup (pg_dump_all) Windows/Linux.  ("Renato Forti" <re.tf@acm.org>)
List pgsql-admin
On Wed, Jan 8, 2014 at 9:15 AM, Renato Forti <re.tf@acm.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.ru@gmail.com


pgsql-admin by date:

Previous
From: Rahul Saha
Date:
Subject: Re: Streaming Replication with different FIle System
Next
From: "Renato Forti"
Date:
Subject: RES: Remote Backup (pg_dump_all) Windows/Linux.