X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 976E111F6AFD for ; Tue, 18 Apr 2006 10:42:19 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.549 X-Spam-Level: X-Spam-Status: No, score=-2.549 required=5 tests=[AWL=0.050, BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id 1z6ivGha0WFB for ; Tue, 18 Apr 2006 10:42:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.tgds.net (tgds.net [212.100.249.157]) by postgresql.org (Postfix) with ESMTP id 4C7EC11F6AC4 for ; Tue, 18 Apr 2006 10:42:11 -0300 (ADT) Received: from hush.localdomain (localhost [127.0.0.1]) by mail.tgds.net (Postfix) with ESMTP id 4CB251435E5; Tue, 18 Apr 2006 14:40:54 +0100 (BST) Subject: Re: downward dump compatibility From: tony To: andy.shellam@mailnetwork.co.uk Cc: pgsql-admin@postgresql.org In-Reply-To: <20060418133119.3CD4D1435E5@mail.tgds.net> References: <20060418133119.3CD4D1435E5@mail.tgds.net> Content-Type: text/plain; charset=ISO-8859-15 Date: Tue, 18 Apr 2006 15:42:10 +0200 Message-Id: <1145367730.6569.39.camel@hush.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 8bit X-Archive-Number: 200604/165 X-Sequence-Number: 21334 Le mardi 18 avril 2006 à 14:32 +0100, Andy Shellam a écrit : > If you're using your 8.1 already, try the 7.3, to rule out the possibility > of anything in your DB causing a problem to the 8.1 pg_dump. Something along the line of creating a ssh tunnel to the intranet server from the public server. ssh -v -L 5433:localhost:5432 my.intranet.url Then pg_dump --port=5433 dbname > /var/lib/pgsql/data/db.out I'll wait until they've finished work... Tony