Re: ERROR: could not read block 3 in file "base/12511/12270"

> On 12/23/2015 04:17 PM, Paul Jones wrote:
> >
> >I have been having disk errors that have corrupted something in
> >>my postgres database. Other databases work ok:
>
> This isn't the best characterization...the "postgres" data is not a "system" database but rather a convenient default user database. Maybe I'm being overly picky here but seeing "system" in this context does have a connotation that we really don't want to impart onto the "postgres" database.
>
> It is named such because the default user is likewise "postgres" and most utilities when not provided with a database name will use the O/S user's name which, for administrative tasks, is likely to be "postgres" (you really shouldn't use root for DB-admin stuff) and thus those commands will be able to connect without much, if any, additional options supplied.
>
> Its presence, absence, or modification in now way alters the fundamental operation of PostgreSQL; though its lack may frustrate users acclimated to using said defaults.
>

This was one of the big lessons I learned from this. All this time I was
under the mistaken impression that it was special.

> David J.