177085 2007-05-04 20:04 0000 dev-db/postgresql - postgresql homedir and $PGDATA env issues 2008-06-14 11:52:55 0000 1 1 1 Unclassified Gentoo Linux Ebuilds unspecified All Linux RESOLVED FIXED P2 normal --- 183764 1 david@fetter.org pgsql-bugs@gentoo.org blackace@gentoo.org esigra@gmail.com plaes@plaes.org david@fetter.org 2007-05-04 20:04:13 0000 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 jakub@gentoo.org 2007-05-04 20:08:44 0000 Move your ASCII vs. unicode vs. whatever issues to Bug 49864 please... plaes@plaes.org 2007-06-27 14:14:36 0000 When postgres homedir is /var/lib, then it isn't writable for postgres user. dev-zero@gentoo.org 2008-06-14 11:52:55 0000 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.