Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W0xSi-0000Rn-3a for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jan 2014 18:02:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W0xSh-0006ef-JO for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jan 2014 18:02:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W0xSg-0006eZ-Tu for pgsql-admin@postgresql.org; Wed, 08 Jan 2014 18:02:38 +0000 Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W0xSe-0005FK-Ja for pgsql-admin@postgresql.org; Wed, 08 Jan 2014 18:02:38 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1W0xSd-0000sr-G1 for pgsql-admin@postgresql.org; Wed, 08 Jan 2014 19:02:35 +0100 Received: from cpc3-walt15-2-0-cust148.13-2.cable.virginm.net ([86.21.186.149]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 08 Jan 2014 19:02:35 +0100 Received: from walterhurry by cpc3-walt15-2-0-cust148.13-2.cable.virginm.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 08 Jan 2014 19:02:35 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Walter Hurry Subject: Re: Remote Backup (pg_dump_all) Windows/Linux. Date: Wed, 8 Jan 2014 18:02:12 +0000 (UTC) Lines: 17 Message-ID: References: <013301cf0c95$43e84670$cbb8d350$@acm.org> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: cpc3-walt15-2-0-cust148.13-2.cable.virginm.net User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Wed, 08 Jan 2014 15:15:42 -0200, Renato Forti wrote: > 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? pg_dumpall (no second underscore) I don't think it needs to be the same bitness, but certainly the same version would seem sensible. It would be slow, though. How big are your databases? Why not just run it on the Linux box? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin