pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedError when trying to do a recovery
3+ messages / 2 participants
[nested] [flat]
* Error when trying to do a recovery
@ 2005-03-01 21:26 Warren Little <warren.little@meridiascapital.com>
0 siblings, 1 reply; 3+ messages in thread
From: Warren Little @ 2005-03-01 21:26 UTC (permalink / raw)
To: pgsql-admin
Hello,
I trying to do a restore using from the online backups. I have restored
the data backup (untarred) and removed all files from the pg_xlog
directory. I also deleted and recreated the archive_status directory
under pg_xlog. I created the recovery.conf file with only the
restore_command in it.
When I start postgres (pg_ctl -l logfile start). The following text is
all that exists in the logfile:
<2005-03-01 14:21:43 MST>FATAL: incorrect checksum in control file
What control file is it referring to? Is there some way to generate
more verbose logging?
thanks
Warren Little
Meridias Capital
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Error when trying to do a recovery
@ 2005-03-02 06:22 Tom Lane <tgl@sss.pgh.pa.us>
parent: Warren Little <warren.little@meridiascapital.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2005-03-02 06:22 UTC (permalink / raw)
To: Warren Little <warren.little@meridiascapital.com>; +Cc: pgsql-admin
Warren Little <warren.little@meridiascapital.com> writes:
> When I start postgres (pg_ctl -l logfile start). The following text is
> all that exists in the logfile:
> <2005-03-01 14:21:43 MST>FATAL: incorrect checksum in control file
> What control file is it referring to?
$PGDATA/global/pg_control. I think this must mean that you are trying
to start a postmaster that is fundamentally incompatible with the old
postmaster --- enough so that it thinks the pg_control struct should be
a different size than the old postmaster thought.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Error when trying to do a recovery
@ 2005-03-02 13:40 Warren Little <warren.little@meridiascapital.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Warren Little @ 2005-03-02 13:40 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Tom,
Thanks for your response. I found an old thread you had responded to a
while back
regarding 32 vs 64 bit architectures (which I have) and compatibility
issues.
So until I upgrade my backup/test box looks like I'm stuck using
pg_dump :(
Thanks
On Wed, 2005-03-02 at 01:22 -0500, Tom Lane wrote:
> Warren Little <warren.little@meridiascapital.com> writes:
> > When I start postgres (pg_ctl -l logfile start). The following text is
> > all that exists in the logfile:
>
> > <2005-03-01 14:21:43 MST>FATAL: incorrect checksum in control file
>
> > What control file is it referring to?
>
> $PGDATA/global/pg_control. I think this must mean that you are trying
> to start a postmaster that is fundamentally incompatible with the old
> postmaster --- enough so that it thinks the pg_control struct should be
> a different size than the old postmaster thought.
>
> regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-03-02 13:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-01 21:26 Error when trying to do a recovery Warren Little <warren.little@meridiascapital.com>
2005-03-02 06:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-03-02 13:40 ` Warren Little <warren.little@meridiascapital.com>
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