pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_restore fails with postgis
3+ messages / 2 participants
[nested] [flat]

* pg_restore fails with postgis
@ 2005-12-12 15:23 Josh O'Brien <obrien@zedxinc.com>
  2005-12-12 16:50 ` Re: pg_restore fails with postgis Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Josh O'Brien @ 2005-12-12 15:23 UTC (permalink / raw)
  To: pgsql-admin

Hello all

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.

Attachments:

obrien.vcf (text/x-vcard, 111B) download begin:vcard fn:Joshua O'Brien n:O'Brien;Joshua org:Zedx Inc. title:Database Administrator version:2.1 end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: pg_restore fails with postgis
  2005-12-12 15:23 pg_restore fails with postgis Josh O'Brien <obrien@zedxinc.com>
@ 2005-12-12 16:50 ` Michael Fuhr <mike@fuhr.org>
  2005-12-12 20:15   ` Re: pg_restore fails with postgis Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Michael Fuhr @ 2005-12-12 16:50 UTC (permalink / raw)
  To: Josh O'Brien <obrien@zedxinc.com>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pg_restore fails with postgis
  2005-12-12 15:23 pg_restore fails with postgis Josh O'Brien <obrien@zedxinc.com>
  2005-12-12 16:50 ` Re: pg_restore fails with postgis Michael Fuhr <mike@fuhr.org>
@ 2005-12-12 20:15   ` Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Michael Fuhr @ 2005-12-12 20:15 UTC (permalink / raw)
  To: Josh O'Brien <obrien@zedxinc.com>; +Cc: pgsql-admin

[Please copy the mailing list on replies.]

On Mon, Dec 12, 2005 at 11:57:06AM -0500, Josh O'Brien wrote:
> this is the command --create --format=c -d template1 
> /home/postgres/dumps/test_dump test_db.

That's not a complete command; I assume those are the options and
arguments to pg_restore.  As far as I can tell from the documentation
and tests the final argument of "test_db" serves no purpose and is
ignored.

> I'm not getting an error message it just doesn't restore any of the tables.

That contradicts your previous message, in which you said:

> >>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.

Do you mean that pg_restore doesn't give any errors but the server
logs do?  Please clarify, and if you're getting errors anywhere
then please post the exact text (copy and paste -- don't type the
error messages by hand).

It might help if you could post a complete test case: all commands
and SQL statements that create, populate, dump, and restore a simple
test database.  That way we can see from start to finish what you're
doing, which might make finding the problem easier.

-- 
Michael Fuhr



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-12-12 20:15 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-12 15:23 pg_restore fails with postgis Josh O'Brien <obrien@zedxinc.com>
2005-12-12 16:50 ` Michael Fuhr <mike@fuhr.org>
2005-12-12 20:15   ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox