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 8B1E09DD20D for ; Mon, 12 Dec 2005 12:50:45 -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 82227-09 for ; Mon, 12 Dec 2005 12:50:38 -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 5555B9DD58E for ; Mon, 12 Dec 2005 12:50:36 -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 jBCGoTQF084325 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Mon, 12 Dec 2005 09:50:32 -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 jBCGoTFU050440; Mon, 12 Dec 2005 09:50:29 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id jBCGoSKC050439; Mon, 12 Dec 2005 09:50:28 -0700 (MST) (envelope-from mfuhr) Date: Mon, 12 Dec 2005 09:50:28 -0700 From: Michael Fuhr To: "Josh O'Brien" Cc: pgsql-admin@postgresql.org Subject: Re: pg_restore fails with postgis Message-ID: <20051212165028.GA38784@winnie.fuhr.org> References: <439D95DD.3030409@zedxinc.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <439D95DD.3030409@zedxinc.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.022 required=5 tests=[AWL=0.022] X-Spam-Score: 0.022 X-Spam-Level: X-Archive-Number: 200512/96 X-Sequence-Number: 19816 On Mon, Dec 12, 2005 at 10:23:09AM -0500, Josh O'Brien wrote: > I'm trying to restore in a cluster using pg_restore and i'm receiving an > error from my recoverylog saying that there is no last checkpoint for my > backend. How can I alter pg_restore to make it work or do i have any > other options. Tahnk you in advance. What's the exact command you're running and what's the exact text of the error message? What versions of PostgreSQL and PostGIS are you using? If you're doing an upgrade then please mention the old and new versions of both. Are you aware that restoring a PostGIS database might require a special procedure? http://postgis.refractions.net/docs/ch02.html#upgrading -- Michael Fuhr