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 617AB9DCA7C for ; Thu, 12 Jan 2006 13:30:30 -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 11214-04 for ; Thu, 12 Jan 2006 13:30:29 -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 CE9519DC84A for ; Thu, 12 Jan 2006 13:30:23 -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 k0CHUKHU010209 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 12 Jan 2006 10:30:22 -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 k0CHUJX9000993; Thu, 12 Jan 2006 10:30:19 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k0CHUJXR000992; Thu, 12 Jan 2006 10:30:19 -0700 (MST) (envelope-from mfuhr) Date: Thu, 12 Jan 2006 10:30:19 -0700 From: Michael Fuhr To: "Josh O'Brien" Cc: pgsql-admin@postgresql.org Subject: Re: upgrade help Message-ID: <20060112173019.GA962@winnie.fuhr.org> References: <43C6646C.2060901@zedxinc.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43C6646C.2060901@zedxinc.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.094 required=5 tests=[AWL=0.094] X-Spam-Score: 0.094 X-Spam-Level: X-Archive-Number: 200601/152 X-Sequence-Number: 20240 On Thu, Jan 12, 2006 at 09:15:08AM -0500, Josh O'Brien wrote: > I am upgrading from postgresql version 7.4 to 8.1 and i'm having a > problem with pg_restore. It is not recognizing the \N command as > inserting a null value. Does anyone know how to fix this? Please post the exact commands you ran and the exact error messages or undesired behavior you're seeing. Be sure to mention the client and server versions for each command (e.g., 8.1.2 pg_dump connecting to 7.4.11 server, and so on). -- Michael Fuhr