Bug 177085

Summary:	dev-db/postgresql - postgresql homedir and $PGDATA env issues
Product:	Gentoo Linux	Reporter:	David Fetter <david>
Component:	New packages	Assignee:	PgSQL Bugs <pgsql-bugs>
Status:	RESOLVED FIXED
Severity:	normal	CC:	blackace, esigra, plaes
Priority:	High
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---
Bug Depends on:
Bug Blocks:	183764

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.