Bug List: (This bug is not in your last search results)   Show last search results      Search page      Enter new bug
Bug#: 177085
Alias:
Product:
Component:
Status: RESOLVED
Resolution: FIXED
Assigned To: PgSQL Bugs <pgsql-bugs@gentoo.org>
Hardware:
OS:
Version:
Priority:
Severity:
Reporter: David Fetter <david@fetter.org>
Add CC:
CC:
Remove selected CCs
URL:
Summary:
Status Whiteboard:
Keywords:

Filename Description Type Creator Created Size Actions
Create a New Attachment (proposed patch, testcase, etc.) View All

Bug 177085 depends on: Show dependency tree
Bug 177085 blocks: 183764
Votes: 0    Show votes for this bug    Vote for this bug

Additional Comments: (this is where you put emerge --info)


Not eligible to see or edit group visibility for this bug.






View Bug Activity   |   Format For Printing   |   XML   |   Clone This Bug

Description:   Opened: 2007-05-04 20:04 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

------- Comment #1 From Jakub Moc (RETIRED) 2007-05-04 20:08:44 0000 ------- 
Move your ASCII vs. unicode vs. whatever issues to Bug 49864 please...

------- Comment #2 From Priit Laes (IRC: plaes) 2007-06-27 14:14:36 0000 ------- 
When postgres homedir is /var/lib, then it isn't writable for postgres user.

------- Comment #3 From Tiziano Müller 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.
Bug List: (This bug is not in your last search results)   Show last search results      Search page      Enter new bug