> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
