Re: pg_restore fails with postgis

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Josh O'Brien" <obrien(at)zedxinc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore fails with postgis
Date: 2005-12-12 16:50:28
Message-ID: 20051212165028.GA38784@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2005-12-12 20:15:40 Re: pg_restore fails with postgis
Previous Message Tom Lane 2005-12-12 16:25:05 Re: separate WAL