| 1 |
On May 21, 2016 4:36:41 AM GMT+02:00, waltdnes@××××××××.org wrote: |
| 2 |
> Yes, I did RTFM at https://wiki.gentoo.org/wiki/PostgreSQL/QuickStart |
| 3 |
>and that's part of my problem. <G> I figured it would be a simple |
| 4 |
>search and replace "9.3" ==> "9.5" in the wiki, but... |
| 5 |
> |
| 6 |
>1) The wiki recommends... |
| 7 |
>PG_INITDB_OPTS="--locale=en_US.UTF-8" |
| 8 |
> |
| 9 |
>...but I get... |
| 10 |
> |
| 11 |
>> The database cluster will be initialized with locale |
| 12 |
>"en_US.iso88591". |
| 13 |
>> initdb: "en_US.UTF8" is not a valid server encoding name |
| 14 |
> |
| 15 |
>"locale -a" returns... |
| 16 |
>C |
| 17 |
>POSIX |
| 18 |
>en_US |
| 19 |
>en_US.iso88591 |
| 20 |
>en_US.utf8 |
| 21 |
> |
| 22 |
>2) The wiki says... |
| 23 |
>> This time the focus is upon the files in the PGDATA directory, |
| 24 |
>> /etc/postgresql-9.3 , instead with primary focus on the |
| 25 |
>> postgresql.conf and pg_hba.conf files. |
| 26 |
> |
| 27 |
>"ls /etc/postgresql-9.5/" returns... |
| 28 |
>postgresql.conf psqlrc |
| 29 |
> |
| 30 |
>but postgresql seems to want them in /var/lib instead... |
| 31 |
> |
| 32 |
>> mv: cannot stat '/var/lib/postgresql/9.5/data/pg_hba.conf': No such |
| 33 |
>> file or directory |
| 34 |
>> mv: cannot stat '/var/lib/postgresql/9.5/data/pg_ident.conf': No |
| 35 |
>> such file or directory |
| 36 |
>> mv: cannot stat '/var/lib/postgresql/9.5/data/postgresql.conf': |
| 37 |
>> No such file or directory |
| 38 |
> |
| 39 |
> Can somebody please confirm the correct way to go? |
| 40 |
> |
| 41 |
> Why I want postgresql... I've been keeping a bunch of data in a |
| 42 |
>spreadsheet, and it's gotten too large. The spreadsheet locks up my |
| 43 |
>system when I try to update it. I've used "top" and watched as |
| 44 |
>gnumeric's memory consumption grows to eat all available ram. It locks |
| 45 |
>up the system so I can't even ssh in. This is on an X86_64 with 8 gigs |
| 46 |
>of RAM! Fortunately, "magic-sysrq" allows a relatively clean shutdown. |
| 47 |
>While we're at it, is there a way for gnumeric to pull in data directly |
| 48 |
>from postgresql? ODBC? I'm aware of copying from postgresql to a CSV |
| 49 |
>file and importing that, but it's rather clunky. |
| 50 |
> |
| 51 |
> My main problem is that columns of several thousand rows are functions |
| 52 |
>based on other columns of several thousand rows. For the time-being, |
| 53 |
>I've split up the spreadsheet into a few pieces, but a database is the |
| 54 |
>best solution. If I could run the calculations in the database, and |
| 55 |
>pull in the final results as static numbers for graphing, that would |
| 56 |
>greatly reduce the strain on the spreadsheet. Or is it possible to |
| 57 |
>graph directly from postgresql? |
| 58 |
> |
| 59 |
> I used to work with Oracle and PL/SQL before I retired, so I think I |
| 60 |
>know what I'm getting into as far as the database stuff is concerned. |
| 61 |
>Once I get past the Gentoo-specific install problems, I'll subscribe to |
| 62 |
>a postgresql mailing list, and ask postgresql-specific questions there. |
| 63 |
|
| 64 |
Quick response. Longer one later when I have access to the database server. |
| 65 |
|
| 66 |
I don't use the wiki, instead I follow the post-emerge messages. |
| 67 |
|
| 68 |
UTF8 is possible. I only use that. |
| 69 |
Not sure about gnumeric, bit libreoffice can read directly from postgresql. |
| 70 |
ODBC is not as simple on Linux as it is on Windows. But when configured, it should work as well. |
| 71 |
Exporting data to CSV is mentioned in several howtos and in the manpage of psql (commandline tool) |
| 72 |
|
| 73 |
-- |
| 74 |
Joost |
| 75 |
-- |
| 76 |
Sent from my Android device with K-9 Mail. Please excuse my brevity. |
Archives