From: Tom Lane on
Jaime Casanova <jcasanov(a)systemguards.com.ec> writes:
> + WARNING: could not open statistics file "pg_stat_tmp/pgstat.stat":
> Stale NFS file handle

> this is an ext2 filesystem in an external hard drive, could be fs corruption?

Evidently the kernel is confused. It seems more like busted in-memory
state than on-disk state, but that's just a guess.

> anything i could do to fix this without dropping my 90Gb test env?

Did you try rebooting the machine?

regards, tom lane

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

From: Jaime Casanova on
On Sun, Apr 4, 2010 at 11:57 AM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote:
>
>> anything i could do to fix this without dropping my 90Gb test env?
>
> Did you try rebooting the machine?
>

yes. i started it a few minutes ago since yesterday... so i think this
is on-disk state, i will checked the disk...


--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

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