Control: tags 703277 confirmed On Sun, 17 Mar 2013 22:43:26 +0000 Andrey Rahmatullin <w...@wrar.name> wrote: > I've experienced this with the tt-rss package but I don't think it's > package-specific.
While debugging bug 789445 in bandwidthd-pgsql I experienced the same. > First, dbconfig-common tells that connecting via the UNIX socket is the best > way at least performance-wise. Second, it tells that using the ident > authentication is not only the best way but also recommended with default > PostgreSQL settings. > > The default PostgreSQL 9.1 Debian settings allow only 'peer' on the local UNIX > socket, so the password authentication simply won't work with the UNIX socket. > And 'ident'/'peer' requires matching between the DB user name (the default for > which is chosen by dbconfig-common and changing that default is usually wrong) > and the system user name (which usually cannot be changed, and when it can the > administrator must do that manually, including the user creation). > > This all means that without reconfiguring the DB server the only usable > setting > is TCP/IP+'password' even for the local server, despite all dbconfig-common > suggestions. It is worse, at the default debconf priority it doesn't even ask these questions so it just doesn't work without manual intervention afterwards. Paul
signature.asc
Description: OpenPGP digital signature
