Re: Problem with pg_upgrade

On Fri, Jul 06, 2012 at 01:20:21PM -0400, Payal Singh wrote:
> Hi,
>
> I restored the backup on 9.1, made sure the database reached a consistent state
> and checkpointed. Then I performed the upgrade. Upgrade completed successfully
> but on running vacuumdb it gave the exact same error. The contents of log file
> are:
>
>
> 1. 2012-07-06 12:08:08 EDT [] [21723]: [1-1] user=,db=,e=00000: LOG: database
> system was interrupted while in recovery at log time 2012-07-03 03:07:02
> EDT

Any idea why you are seeing the above "interrupted while in recovery"
message?

> 2. 2012-07-06 12:08:08 EDT [] [21723]: [2-1] user=,db=,e=00000: HINT: If this
> has occurred more than once some data might be corrupted and you might need
> to choose an earlier recovery target.
> 3. 2012-07-06 12:08:08 EDT [] [21723]: [3-1] user=,db=,e=00000: LOG: creating
> missing WAL directory "pg_xlog/archive_status"
> 4. 2012-07-06 12:08:08 EDT [] [21723]: [4-1] user=,db=,e=00000: LOG: database
> system was not properly shut down; automatic recovery in progress

The above is also confusing. pg_upgrade uses pg_ctl -w stop/start, so I
am confused, how it could show as recovering.

>
> Also, this time I did not run vacuumdb on old server before performing the
> upgrade.

I think you had better show us exactly what you are doing here --- how
you are setting up these clusters, how you are running pg_upgrade, what
commands you are typing, etc.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +