422831 – >=dev-db/postgresql-server-9.1: /run/postgresql directory has wron permissions

Bug 422831 - >=dev-db/postgresql-server-9.1: /run/postgresql directory has wron permissions

Summary: >=dev-db/postgresql-server-9.1: /run/postgresql directory has wron permissions

Status:	RESOLVED DUPLICATE of bug 395331

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	Current packages (show other bugs)
Hardware:	All Linux

Importance:	Normal normal
Assignee:	PgSQL Bugs

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2012-06-21 11:37 UTC by Marc Schiffbauer
Modified:	2012-06-21 12:14 UTC (History)
CC List:	0 users

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Marc Schiffbauer gentoo-dev

2012-06-21 11:37:24 UTC

Postgres normally allows access via socket for local users if a line of type "local" with method "trust" exists for a user/database pair in the pg_hba.conf file.

However: The current default permissions of /run/postgresql - where the socket lives - do not allow any user to access the socket.

Please change permission from 

drwxrwx--- 2 postgres postgres 80 21. Jun 13:12 /run/postgresql

to

drwxrwx--x 2 postgres postgres 80 21. Jun 13:12 /run/postgresql

Comment 1 Aaron W. Swenson gentoo-dev

2012-06-21 12:14:14 UTC

The post-install message and the how-to document that the Linux user must be in the 'postgres' group.

pg_hba.conf only defines rules for PostgreSQL roles.

*** This bug has been marked as a duplicate of bug 395331 ***