pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Error 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>
  2005-03-02 06:22 ` Re: Error when trying to do a recovery Tom Lane <tgl@sss.pgh.pa.us>
  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-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   ` Re: Error when trying to do a recovery 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-01 21:26 Error when trying to do a recovery Warren Little <warren.little@meridiascapital.com>
  2005-03-02 06:22 ` Re: Error when trying to do a recovery Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-03-02 13:40   ` Warren Little <warren.little@meridiascapital.com>
  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