From re.tf@acm.org Wed Jan 8 17:15:53 2014 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W0wjR-00074D-Ec for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jan 2014 17:15:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W0wjQ-0006GV-Ng for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jan 2014 17:15:52 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W0wjP-0006GO-Eq for pgsql-admin@postgresql.org; Wed, 08 Jan 2014 17:15:51 +0000 Received: from atl4mhob11.myregisteredsite.com ([209.17.115.49]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W0wjH-0005tN-JF for pgsql-admin@postgresql.org; Wed, 08 Jan 2014 17:15:50 +0000 Received: from mailpod.hostingplatform.com ([10.30.71.206]) by atl4mhob11.myregisteredsite.com (8.14.4/8.14.4) with ESMTP id s08HFgZu018768 for ; Wed, 8 Jan 2014 12:15:42 -0500 Received: (qmail 1615 invoked by uid 0); 8 Jan 2014 17:15:42 -0000 X-TCPREMOTEIP: 189.55.5.60 X-Authenticated-UID: re.tf@dokfile.com Received: from unknown (HELO pcrenato) (re.tf@dokfile.com@189.55.5.60) by 0 with ESMTPA; 8 Jan 2014 17:15:42 -0000 From: "Renato Forti" To: Subject: Remote Backup (pg_dump_all) Windows/Linux. Date: Wed, 8 Jan 2014 15:15:42 -0200 Message-ID: <013301cf0c95$43e84670$cbb8d350$@acm.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0134_01CF0C84.8062D1D0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac8MlT3wttl5mIxURn+JLnesyunOQQ== Content-Language: pt-br X-Pg-Spam-Score: 2.2 (++) 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 This is a multipart message in MIME format. ------=_NextPart_000_0134_01CF0C84.8062D1D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi All, I have one question about backup (pg_dump_all). If anyone can helpeme! 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? What command option (pg_dump_all) I can use to do this? Thanks ------=_NextPart_000_0134_01CF0C84.8062D1D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi All,

 

I have one question about backup = (pg_dump_all).

 

If anyone can helpeme!

 

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?

 

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

 

Thanks

 

------=_NextPart_000_0134_01CF0C84.8062D1D0-- From walterhurry@gmail.com Wed Jan 8 18:02:40 2014 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 From gray.ru@gmail.com Thu Jan 9 02:08:08 2014 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W152W-0001EM-17 for pgsql-admin@arkaria.postgresql.org; Thu, 09 Jan 2014 02:08:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W152V-0006CL-5V for pgsql-admin@arkaria.postgresql.org; Thu, 09 Jan 2014 02:08:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W152U-0006CF-DQ for pgsql-admin@postgresql.org; Thu, 09 Jan 2014 02:08:06 +0000 Received: from mail-ie0-x231.google.com ([2607:f8b0:4001:c03::231]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W152R-0005ih-0K for pgsql-admin@postgresql.org; Thu, 09 Jan 2014 02:08:05 +0000 Received: by mail-ie0-f177.google.com with SMTP id tp5so2937119ieb.22 for ; Wed, 08 Jan 2014 18:08:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; bh=K1utKL72fWL4f+ofUJalC/QS/h/dLSzg196WAXpmrFA=; b=x7OOYW7g0booO2xeTxi58pITTf+Jzb1s4ojFfmttzXGBpWZd0Yt4ZaBObX7Y3aa4OO wVVYBSfKZNJTqsoQfrd95kYTNwCzqBecXQ/vsfOZ8gqvpFKQuNS8ze8SoOhCREH28Kev +vy2PW1MQa2O813X0qe1bpFbBAAdlqdnuPVUmbasGVa2hiiWBIGHSAjDqS6aayftFwla jAa0k4X/wQL2EKwYLLpqJms9KCjtG5d2Ouz8cZM589A0Mqby0yQO+yFiach0ucrQA1Sp AXbgzYtBpHPIp9tqpscbsbPIROW6DXLlLRfLplC3ajt/pgCSyKpOlcZSDHwSGzBl5aGp yppg== X-Received: by 10.50.119.4 with SMTP id kq4mr996527igb.40.1389233274081; Wed, 08 Jan 2014 18:07:54 -0800 (PST) MIME-Version: 1.0 Received: by 10.42.93.142 with HTTP; Wed, 8 Jan 2014 18:07:33 -0800 (PST) In-Reply-To: <013301cf0c95$43e84670$cbb8d350$@acm.org> References: <013301cf0c95$43e84670$cbb8d350$@acm.org> From: Sergey Konoplev Date: Wed, 8 Jan 2014 18:07:33 -0800 Message-ID: Subject: Re: Remote Backup (pg_dump_all) Windows/Linux. To: Renato Forti Cc: pgsql-admin Content-Type: text/plain; charset=ISO-8859-1 X-Pg-Spam-Score: -2.0 (--) 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, Jan 8, 2014 at 9:15 AM, Renato Forti 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin