177085 – dev-db/postgresql - postgresql homedir and $PGDATA env issues

Bug 177085 - dev-db/postgresql - postgresql homedir and $PGDATA env issues

Summary: dev-db/postgresql - postgresql homedir and $PGDATA env issues

Status:	RESOLVED FIXED

Alias:	None

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

Importance:	High normal (vote)
Assignee:	PgSQL Bugs

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:	183764
	Show dependency tree

Reported:	2007-05-04 20:04 UTC by David Fetter
Modified:	2008-06-14 11:52 UTC (History)
CC List:	3 users (show)

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 David Fetter 2007-05-04 20:04:13 UTC

A few things aren't quite right in PostgreSQL setup:

* initdb defaults to using SQL_ASCII encoding.  This is almost never right, and UTF8 is a safe default.

* The postgres users's home directory is /var/lib and not /var/lib/postgresql

* The postgres user's environment does not contain $PGDATA

Comment 1 Jakub Moc (RETIRED) gentoo-dev

2007-05-04 20:08:44 UTC

Move your ASCII vs. unicode vs. whatever issues to Bug 49864 please...

Comment 2 Priit Laes (IRC: plaes) 2007-06-27 14:14:36 UTC

When postgres homedir is /var/lib, then it isn't writable for postgres user.

Comment 3 Tiziano Müller (RETIRED) gentoo-dev

2008-06-14 11:52:55 UTC

The $PGDATA issue is in bug #110912 (not sure what to do about it).
The postgres user's home dir is now /var/lib/postgresql and "emerge --config" reads an env var to set the default encoding.