> >> That won't help; that would introduce the "embarrassment" of having a > >> known default password. > > > No it wouldn't unless the packagers set it up to do that. My point is > > that when a packager (or source) runs initdb, it would prompt for the > > postgres user password. > > Practically every existing packaging of PG tries to run initdb as a > hidden, behind-the-scenes, definitely not-interactive procedure. >
afaik, practically every existing packaging of pg has *already* solved the problem and does not set trust as default anyway. ident sameuser I think is the most common. One thing I've thought about doing is to remove the default in initdb completely and *force* the user to choose auth type. Packagers can then just use that to set ident or whatever. and interactive users can pick trust if they really need it, but it will be a known choice. /Magnus ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq