Postgres Pro
Downloads
Home   >   mailing lists

Re: wrong size archive file - Mailing list pgsql-admin

From Denish Patel
Subject Re: wrong size archive file
Date
Msg-id CAFddxvOY4Ly3G9-he_+GY90LWaCA6QakLoF25UXoW8OEdRJV3w@mail.gmail.com
Whole thread Raw
In response to wrong size archive file  ("Ginepro, Raymond C" <GineproR@aetna.com>)
Responses Re: wrong size archive file
List pgsql-admin
Tree view
Before going into recovery discussion, I would like to learn about how did you take a backup ?  Have you followed "Making A Base Backup" procedure documented in http://www.postgresql.org/docs/9.2/static/continuous-archiving.html ?

On Wed, Oct 23, 2013 at 2:56 PM, Ginepro, Raymond C <GineproR@aetna.com> wrote:
Good afternoon,

I am testing out recovery on 9.2 postgres and I am getting the following message when I try to start up the cluster:



FATAL:  archive file "00000001000000000000004C" has wrong size: 305 instead of 16777216



This archive log was active at the start of the backup and is not 16M in size in the original pg_xlog.  How do I get around this?  Is there a fix for this?





This e-mail may contain confidential or privileged information. If

you think you have received this e-mail in error, please advise the

sender by reply e-mail and then delete this e-mail immediately.

Thank you. Aetna


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



--
Denish Patel,
OmniTi Computer Consulting Inc.
Database Architect,
Phone: 240.646.0770 x 232

pgsql-admin by date:

Previous
From: "Ginepro, Raymond C"
Date:
Subject: wrong size archive file
Next
From: "Ginepro, Raymond C"
Date:
Subject: Re: wrong size archive file