X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1BAFA9DCA45 for ; Tue, 24 Jan 2006 04:34:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07336-01 for ; Tue, 24 Jan 2006 04:34:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail07.powweb.com (mail07.powweb.com [66.152.97.40]) by postgresql.org (Postfix) with ESMTP id CBD4E9DC9F8 for ; Tue, 24 Jan 2006 04:34:15 -0400 (AST) Received: from [10.1.0.10] (unknown [82.76.86.38]) by mail07.powweb.com (Postfix) with ESMTP id 8F7AA14DAFF; Tue, 24 Jan 2006 00:34:15 -0800 (PST) Message-ID: <43D5E66E.9020002@bitsp.com> Date: Tue, 24 Jan 2006 10:33:50 +0200 From: Ciprian Hodorogea Reply-To: ciprian.hodorogea@bitsp.com Organization: IntelliSoft SRL User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane CC: Michael Fuhr , pgsql-admin@postgresql.org Subject: Re: pg_dump - txt sql vs binary References: <20060122204132.9567D14DB13@mail07.powweb.com> <22930.1137973880@sss.pgh.pa.us> <43D4E9A8.8050005@bitsp.com> <20060123155729.GA23544@winnie.fuhr.org> <43D5091C.9010608@bitsp.com> <6688.1138036985@sss.pgh.pa.us> In-Reply-To: <6688.1138036985@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/273 X-Sequence-Number: 20361 > > pg_dump is certainly the preferred method. > I have Postgres 8.1.1 installed on a Windows machine and on a Linux machine. When I do pg_dump (from Windows) and then pg_restore from Linux, I get 52 errors, which I ignore and things seem to work fine, but I suppose something is wrong about this... It is only the setup from the website that I have installed and not other contribs. Best Regards, Ciprian