Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 323683 - dev-db/postgresql-server: notice about the move of the postgres socket is easily missed.
Summary: dev-db/postgresql-server: notice about the move of the postgres socket is eas...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] Unspecified (show other bugs)
Hardware: AMD64 Linux
: High normal (vote)
Assignee: PgSQL Bugs
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-12 15:04 UTC by Robert Bridge
Modified: 2011-03-21 04:17 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
A patch to the postgresql-server-8.4.4-r1 ebuild with a more explicit warning. (postgres-ewarn.patch,598 bytes, patch)
2010-06-12 15:07 UTC, Robert Bridge
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Bridge 2010-06-12 15:04:34 UTC
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
Comment 1 Robert Bridge 2010-06-12 15:07:29 UTC
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.
Comment 2 Aaron W. Swenson gentoo-dev 2010-06-16 12:25:02 UTC
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.
Comment 3 Aaron W. Swenson gentoo-dev 2011-03-21 04:17:21 UTC
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.