The ewarn relating to the move of the socket to /var/run/postgresql is easily missed. This can cause confusion for users using psql, if they miss the notice about the socket move. Reproducible: Always
Created attachment 235077 [details, diff] A patch to the postgresql-server-8.4.4-r1 ebuild with a more explicit warning. The attached patch should make it far more obvious that users need to be added to the postgres group prior to using psql.
The socket move warning probably doesn't even have to be there. (The socket has been moved for somewhere around two years now.) 'psql' doesn't need to be told by the user where to find the socket. Neither does any of the other client applications that I've used so far. The only thing that the user does need to tell the applications is when the port number deviates from the default. The requirement for users to be in the 'postgres' group might be better mentioned in the pkg_config function. After the cluster has been created.
Fixed. 21 Mar 2011; Aaron W. Swenson <titanofold@gentoo.org> +postgresql-server-8.2.20-r1.ebuild, +postgresql-server-8.3.14-r1.ebuild, +postgresql-server-8.4.7-r1.ebuild, +postgresql-server-9.0.3-r1.ebuild: Fixes bugs 274836, 302384, 323683, 325709, 347005, 347223, 353687 and 353750.