Longer answer: On Friday, May 20, 2016 10:36:41 PM waltd...@waltdnes.org wrote: > Yes, I did RTFM at https://wiki.gentoo.org/wiki/PostgreSQL/QuickStart > and that's part of my problem. <G> I figured it would be a simple > search and replace "9.3" ==> "9.5" in the wiki, but...
A quick scan should indicate that. However: PG_INITDB_OPTS="--locale=en_US.UTF-8 --lc-messages=sv_SE.UTF-8" is wrong. See below. > 1) The wiki recommends... > PG_INITDB_OPTS="--locale=en_US.UTF-8" Where did you configure this? I did the following: # cat /etc/conf.d/postgresql-9.5 | grep -i utf PG_INITDB_OPTS="--encoding=UTF8" > ...but I get... > > > The database cluster will be initialized with locale "en_US.iso88591". > > initdb: "en_US.UTF8" is not a valid server encoding name > > "locale -a" returns... > C > POSIX > en_US > en_US.iso88591 > en_US.utf8 Postgresql only uses the codepage, not the localisation ("en_US") part. > 2) The wiki says... > > > This time the focus is upon the files in the PGDATA directory, > > /etc/postgresql-9.3 , instead with primary focus on the > > postgresql.conf and pg_hba.conf files. > > "ls /etc/postgresql-9.5/" returns... > postgresql.conf psqlrc > > but postgresql seems to want them in /var/lib instead... > > > mv: cannot stat '/var/lib/postgresql/9.5/data/pg_hba.conf': No such > > file or directory > > mv: cannot stat '/var/lib/postgresql/9.5/data/pg_ident.conf': No > > such file or directory > > mv: cannot stat '/var/lib/postgresql/9.5/data/postgresql.conf': > > No such file or directory > > Can somebody please confirm the correct way to go? Did you run emerge --config dev-db/postgresql:9.5 succesfully? > Why I want postgresql... I've been keeping a bunch of data in a > spreadsheet, and it's gotten too large. The spreadsheet locks up my > system when I try to update it. I've used "top" and watched as > gnumeric's memory consumption grows to eat all available ram. It locks > up the system so I can't even ssh in. This is on an X86_64 with 8 gigs > of RAM! Fortunately, "magic-sysrq" allows a relatively clean shutdown. > While we're at it, is there a way for gnumeric to pull in data directly > from postgresql? ODBC? I'm aware of copying from postgresql to a CSV > file and importing that, but it's rather clunky. There are ODBC and native drivers. You need to check which have support directly. Look for "postgres" USE-flags in spreadsheet applications. > My main problem is that columns of several thousand rows are functions > based on other columns of several thousand rows. For the time-being, > I've split up the spreadsheet into a few pieces, but a database is the > best solution. If I could run the calculations in the database, and > pull in the final results as static numbers for graphing, that would > greatly reduce the strain on the spreadsheet. Or is it possible to > graph directly from postgresql? Not to my knowledge, I tend to use spreadsheets or graphics libraries in C++ GUI applications. (Still playing with the latter, so not the best resource for that) > I used to work with Oracle and PL/SQL before I retired, so I think I > know what I'm getting into as far as the database stuff is concerned. > Once I get past the Gentoo-specific install problems, I'll subscribe to > a postgresql mailing list, and ask postgresql-specific questions there. Postgresql has it's own procedural language, might be nice to look into that in that case. I would suggest the USER-mailing list. The development one (HACKERS) deals with the actual internals, not something most users would be interested in. -- Joost