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