Re: PD_ALL_VISIBLE flag warning
| От | Jonathan Foy |
|---|---|
| Тема | Re: PD_ALL_VISIBLE flag warning |
| Дата | |
| Msg-id | j2y4b46b5f01004080803yc018a6cbqf38ceedd6933817d@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PD_ALL_VISIBLE flag warning (Greg Stark <gsstark@mit.edu>) |
| Список | pgsql-admin |
On Thu, Apr 8, 2010 at 10:16 AM, Greg Stark <gsstark@mit.edu> wrote:
Understood. It's my current top priority.
I have never turned off fsync. Also, the server is showing an uptime of 281 days, and the postgres instance has been up since 2/21.
If you're on 8.1 it's important to be on the latest 8.1 -- there are
at least 17 significant bugs that warranted bug-fix releases between
8.1.3 and 8.1.20 including security bugs and data corruption bugs.
Understood. It's my current top priority.
Ugh, then it sounds like there's a real as-yet unidentified problem.
> We never actually ran 8.4.0. We went straight from 8.3.3 to 8.4.1. I did a
> full dump/restore from the 8.3.3 database into the 8.4.1 database (using the
> 8.4 pg_dump), partitioning as I went.
The other thing to check before panicking is, has this server ever run
with fsync off and crashed (either kernel panic or power failure)?
I have never turned off fsync. Also, the server is showing an uptime of 281 days, and the postgres instance has been up since 2/21.
What does the storage system on this server look like? Are they IDE or
SCSI drives? Is there an LVM layer involved? etc.
--
greg
Storage is on an NFS mounted Fiber Netapp volume.
Let me know if you need more...
В списке pgsql-admin по дате отправления: