Re: [GENERAL] PostgreSQL Developer Best Practices

2015-08-25 Thread Christine Desmuke
engine replaced and the DMV insists it have a new number). A lot of "natural" PKs have similar oddities and corner cases that 99.99% of us will never encounter, but you don't want to be in the 0.01%. Artificial keys don't suffer these problems. --christine desmuke --

Re: [GENERAL] Make check fails on 8.3.7

2009-08-07 Thread Christine Desmuke
Alban Hertroys wrote: On 7 Aug 2009, at 4:02, Christine Desmuke wrote: If so, isn't it just the output of stderr getting lost here? What shell are you using? Yes, it looks like stderr is lost. I'm running bash, and there is nothing odd in .bash_profile Any ideas? I have to

Re: [GENERAL] Make check fails on 8.3.7

2009-08-06 Thread Christine Desmuke
Alban Hertroys wrote: On 31 Jul 2009, at 3:25, Christine Desmuke wrote: Samples from the regression.diffs: *** ./expected/boolean.out Fri Jun 1 18:40:19 2007 --- ./results/boolean.out Thu Jul 30 19:16:33 2009 *** *** 75,83 (1 row) SELECT ' tru e &#

Re: [GENERAL] Make check fails on 8.3.7

2009-08-05 Thread Christine Desmuke
Tom Lane wrote: > Christine Desmuke writes: >> Tom Lane wrote: >>> Years ago I saw roughly similar symptoms when SELinux decided postgres >>> shouldn't be allowed to write to /dev/tty. > >> Thanks for the suggestion. It is not SELinux (SELinux status:

Re: [GENERAL] Make check fails on 8.3.7

2009-07-31 Thread Christine Desmuke
Tom Lane wrote: Christine Desmuke writes: I'm trying to install 8.3.7, but can't get past make check. CentOS release 4.7 (Final), with an existing install of 8.3.1 running as a warm standby ... It looks in every case like the ERROR (and also HINT lines) lines are causing the fai

[GENERAL] Make check fails on 8.3.7

2009-07-30 Thread Christine Desmuke
tablespace "testspace" is not empty DROP SCHEMA testschema CASCADE; NOTICE: drop cascades to table testschema.atable NOTICE: drop cascades to table testschema.asexecute --- 56,65 It looks in every case like the ERROR (and also HINT lines) lines are causing the failures, but I'm not s

[GENERAL] Gentoo for production DB server?

2004-08-24 Thread Christine Desmuke
ead or not ready for primetime; in either case, details are sketchy. I would like to hear especially from people who are either running Gentoo in production or have tried and rejected it. Thank you. Christine Desmuke Kansas State Historical Society cdesmuke (at) kshs (dot) org