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 2E3C19DC85B for ; Tue, 24 Jan 2006 17:24:13 -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 39148-10 for ; Tue, 24 Jan 2006 17:24:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id DC0189DC801 for ; Tue, 24 Jan 2006 17:24:10 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k0OLO4BE027378 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Tue, 24 Jan 2006 14:24:07 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k0OLO4Lf091469; Tue, 24 Jan 2006 14:24:04 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k0OLO4wx091468; Tue, 24 Jan 2006 14:24:04 -0700 (MST) (envelope-from mfuhr) Date: Tue, 24 Jan 2006 14:24:04 -0700 From: Michael Fuhr To: Ciprian Hodorogea Cc: Tom Lane , pgsql-admin@postgresql.org Subject: Re: pg_dump - txt sql vs binary Message-ID: <20060124212404.GA91387@winnie.fuhr.org> 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> <43D5E66E.9020002@bitsp.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43D5E66E.9020002@bitsp.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200601/278 X-Sequence-Number: 20366 On Tue, Jan 24, 2006 at 10:33:50AM +0200, Ciprian Hodorogea wrote: > >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... As Tom mentioned, the Windows box apparently has some contributed modules that the Linux box doesn't, so when you try to restore the catalog entries on Linux you get errors. If you know you don't need those modules then you can ignore the errors; if you'd like to have an error-free restore then either add the modules to Linux, remove them from Windows, or delete them from the backup. If you're using pg_restore then you could use the -l/--list and -L/--use-list options to omit certain objects from the restore. See the documentation for an example. > It is only the setup from the website that I have installed and not > other contribs. Did you build from source or did you install a pre-built package? If from source then the contributed modules are in the contrib directory; if from a package then look around for another package that contains the contributed modules. -- Michael Fuhr