pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_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>
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 16:50 Michael Fuhr <mike@fuhr.org>
parent: Josh O'Brien <obrien@zedxinc.com>
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 20:15 Michael Fuhr <mike@fuhr.org>
parent: 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