Re: Vacuum Warning

Lists: pgsql-admin
From: Prasanth <dbadmin(at)nqadmin(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Vacuum Warning
Date: 2005-10-04 14:06:02
Message-ID: 43428C4A.1060203@nqadmin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Hi,

I got this message in my daily vacuum. Is it some thing to worry about?
What exactly does this mean?

vacuumdb: vacuuming database "test_server"
WARNING: relation "account_lists" page 189 is uninitialized --- fixing

Thanks,
-Prasanth.


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dbadmin(at)nqadmin(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum Warning
Date: 2005-10-04 15:35:10
Message-ID: 8682.1128440110@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Prasanth <dbadmin(at)nqadmin(dot)com> writes:
> I got this message in my daily vacuum. Is it some thing to worry about?
> What exactly does this mean?

> vacuumdb: vacuuming database "test_server"
> WARNING: relation "account_lists" page 189 is uninitialized --- fixing

This can happen after a crash; it's harmless AFAIK.

regards, tom lane