Re: [HACKERS] anoncvs failure...

2001-09-22 Thread Dominic J. Eidson
On Sat, 22 Sep 2001, Marc G. Fournier wrote: > anoncvs: :pserer:[EMAIL PROTECTED]:/projects/cvsroot > - passwd is blank, but postgresql should work just as well I can confirm that this works. -- Dominic J. Eidson "Baruk Khazad! Kha

Re: [HACKERS] Re: [PATCHES] Patch to include PAM support...

2001-08-24 Thread Dominic J. Eidson
On Sat, 25 Aug 2001, Tom Lane wrote: > "Dominic J. Eidson" <[EMAIL PROTECTED]> writes: > >> Could we change the PAM code so that it tries to run the PAM auth cycle > >> immediately on receipt of a connection request? If it gets a callback > >> fo

Re: [HACKERS] Failed compile PostgreSQL 7.1.2 on AIX 5.1

2001-07-26 Thread Dominic J. Eidson
looks like you need to add a -lm in there somewhere to include the math library. export LDFLAGS="-lm" should do the job, unless someone else knows the exact place to put it. -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!"

Re: [HACKERS] Odd error...

2001-07-17 Thread Dominic J. Eidson
On Tue, 17 Jul 2001, Philip Warner wrote: > At 22:12 16/07/01 -0500, Dominic J. Eidson wrote: > >morannon:~>pg_dump -t bboard openacs | less > >getTables(): SELECT (for VIEW ec_subsubcategories_augmented) returned NULL > oid > >SELECT was: SELECT definition a

[HACKERS] Odd error...

2001-07-16 Thread Dominic J. Eidson
here viewname = 'ec_subsubcategories_augmented'; Any ideas what would cause this? -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli --- http://www.the-infinite.org/

Re: [HACKERS] Encrypting pg_shadow passwords

2001-06-15 Thread Dominic J. Eidson
se wait till I've finished the "authenticate after > fork" change. (this weekend?) If you are going to do this this weekend, should I just wait with the PAM patch until then? (Patch against the new code) -- Dominic J. Eidson

[HACKERS] PAM Authentication for PostgreSQL...

2001-04-26 Thread Dominic J. Eidson
dly enough, most of them involving LDAP... imagine that. :) Is there any discussion before I submit the patch to -patches? -Dominic -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli -

Re: [HACKERS] How to determine if a user exists..

2001-04-23 Thread Dominic J. Eidson
On Mon, 23 Apr 2001, Tom Lane wrote: > If you're trying to do this from the postmaster, I think the only way is > to look at $PGDATA/global/pg_pwd, which is a flat-file version of > pg_shadow. This is what I thought - thanks. -- Dom

[HACKERS] Re: How to determine if a user exists..

2001-04-23 Thread Dominic J. Eidson
wd... One question I'd have there, is whether pg_pwd always exists (or, can be relied upon existing.)? -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli --

[HACKERS] How to determine if a user exists..

2001-04-22 Thread Dominic J. Eidson
be taken care of elsewhere... I just need to check if the user exists.) thanks, -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli --- http://www.the-in

Re: [HACKERS] Hey guys, check this out.

2001-04-14 Thread Dominic J. Eidson
ense. Oh, and 7.1's due to ship at the end of June... *cough* Somebody should forward Marc's announcement from last night to them. -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli

Re: [HACKERS] Duplicate databases...

2001-04-06 Thread Dominic J. Eidson
On Fri, 6 Apr 2001, Tom Lane wrote: > On closer look, I'll bet that "brandon" and "postgres" have the > same usesysid assigned in pg_shadow. Need to change one of them. That was it - both were 501. Thanks. -- Dominic J. Eidson

Re: [HACKERS] Duplicate databases...

2001-04-06 Thread Dominic J. Eidson
I just love to reply to myself.. On Fri, 6 Apr 2001, Dominic J. Eidson wrote: [Snip] > postgres | brandon <-- Incorrect > postgres | postgres > smc_is_neteng | dominic > template1 | brandon <-- Incorrect > template1 | postgres >

[HACKERS] Duplicate databases...

2001-04-06 Thread Dominic J. Eidson
ws) Any idea what would cause this" (The "<-- Incorrect" was added by me.. ) -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli --- http://ww

Re: [HACKERS] Final call for platform testing

2001-04-03 Thread Dominic J. Eidson
27;01:02' AS "+03:28"; --- 140,146 SELECT time with time zone '03:30' + interval '1 month 04:01' AS "07:31:00-08"; 07:31:00-08 --------- ! 07:31:00-07 (1 row) SELECT interval '04:30' - time with time zo

Re: [HACKERS] Re: third call for platforms...

2001-03-30 Thread Dominic J. Eidson
On Fri, 30 Mar 2001, Dominic J. Eidson wrote: > I have a Cobalt 2.0.x MIPS box that is currently compiling the latest CVS > of PostgreSQL ... I'll let you know in a few hours how it went. Compiled fine, and passed all but the geometry regression test: [root@web-cache reg

[HACKERS] Re: third call for platforms...

2001-03-30 Thread Dominic J. Eidson
( I deleted the email accidentially) I have a Cobalt 2.0.x MIPS box that is currently compiling the latest CVS of PostgreSQL ... I'll let you know in a few hours how it went. # uname -a Linux web-cache 2.0.34C52_SK #1 Tue Nov 30 18:14:40 PST 1999 mips unknown -- Dominic J. E

Re: [HACKERS] Re: Final Call: RC1 about to go out the door ...

2001-03-20 Thread Dominic J. Eidson
the MPC7XX family and the G4s are the MPC7XXX family. All of the ones Mac is currently releasing are MPC7450s. See http://e-www.motorola.com/webapp/sps/prod_cat/taxonomy.jsp?catId=M934309493763 for more details. FWIW.

Re: [HACKERS] Re: Final Call: RC1 about to go out the door ...

2001-03-20 Thread Dominic J. Eidson
, I have a separate listing for "mklinux" for the 7.0 release. Is > that distro still valid and unique? Or is there a better way to > represent the PPC options under Linux? mklinux is older Motorola 68k-based systems LinuxPPC is the newer

Re: [HACKERS] RE: xlog checkpoint depends on sync() ... seems unsafe

2001-03-12 Thread Dominic J. Eidson
e flushing the buffers to disk. - this is what we were told by the IBM engineers when I worked tier-2/3 AIX support at IBM. -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli

Re: [HACKERS] BLCKSZ 0?

2001-02-28 Thread Dominic J. Eidson
On Tue, 27 Feb 2001, Tom Lane wrote: > "Dominic J. Eidson" <[EMAIL PROTECTED]> writes: > > > root@blue:/usr/local/pgsql# su postgres -c "bin/postmaster -D > > /usr/local/pgsql/data " > > DEBUG: Data Base System is starting up at Tue Feb 27 22

[HACKERS] BLCKSZ 0?

2001-02-27 Thread Dominic J. Eidson
h BLCKSZ 0, but the backend was compiled with BLCKSZ 8192. looks like you need to initdb. FATAL 2: database was initialized with BLCKSZ 0, but the backend was compiled with BLCKSZ 8192. looks like you need to initdb. Startup failed - abort -- Dominic

Re: [HACKERS] WAL and commit_delay

2001-02-17 Thread Dominic J. Eidson
rrently (Linux 2.0.23) fdatasync is equivalent to fsync. -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli --- http://www.the-infinite.org/ htt

Re: [HACKERS] Syslog and pg_options (for RPMs)

2001-02-08 Thread Dominic J. Eidson
s also trace it to BSD. I'm surprised syslog > (apparently) hasn't made it into any formal standard. "man syslog" shows the above, "man logger" however, shows this: STANDARDS The logger command is expected to be IEEE Std1003.2 (``POSIX'') compati-

Re: [HACKERS] Syslog and pg_options (for RPMs)

2001-02-08 Thread Dominic J. Eidson
nd interface to the syslog(3) system log module. -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli --- http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/

Re: [HACKERS] Security hole in PL/pgSQL

2001-01-29 Thread Dominic J. Eidson
''_desc text, '' || NEW.dbs_name || ''_qty int4 );''; I don't see how anybody could think you are allowed to execute random garbage through exec*()... -- Dominic J. Eidson "Baruk Khazad! Khazad a

Re: [HACKERS] Re: Sure enough, the lock file is gone

2001-01-28 Thread Dominic J. Eidson
lls they now are. We are 100% > Are there still people who can only install PostgreSQL as a private > application? Private application - or non-root application? -- Dominic J. Eidson "Ba

Re: [HACKERS] GNU readline and BSD license

2000-12-29 Thread Dominic J. Eidson
ine.so.3 => /lib/libreadline.so.3 (0x4009d000) libtermcap.so.2 => /usr/lib/libtermcap.so.2 (0x400c4000) libncurses.so.4 => /lib/libncurses.so.4 (0x400c8000) libc.so.6 => /lib/libc.so.6 (0x4010e000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40

Re: [HACKERS] Assuming that TAS() will succeed the first time isverboten

2000-12-28 Thread Dominic J. Eidson
On Thu, 28 Dec 2000, Nathan Myers wrote: > The code is based on some odd assumptions. A select() with 0 delay > returns immediately unless there is an interrupt during its (very short!) If you look closely, it's a select with a 2 second timeout. >>> { 2, 0 } -

Re: [HACKERS] SSL Connections

2000-12-20 Thread Dominic J. Eidson
passphrase, then copy the certificate and key. Works great. -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli --- http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/

Re: [HACKERS] redundancy and disk i/o

2000-12-04 Thread Dominic J. Eidson
ng the fiber extenders. With those, you can have your drives up to 2.4 km from the server they're connected to, while they still are local to the machine. (And you still get 4 simultaneous reads/writes in each direction of the loop, for a total of 160 Mbyte/sec transfer.) -- Domini

Re: [HACKERS] psql: anyone ever notice?

2000-11-19 Thread Dominic J. Eidson
ain shell's expansion of ? - for the longest time I'd have to do psql -\? to get it to work. -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli ---

Re: [HACKERS] Darn, long option emulation doesn't work on FreeBSD

2000-11-06 Thread Dominic J. Eidson
roken): morannon:~>postmaster -Q postmaster: invalid option -- Q Try -? for help. morannon:~>postgres -Q postgres: invalid option -- Q Usage: postgres [options] [dbname] ... snip ... -- Dominic J. Eidson "Baruk Khaz

Re: [HACKERS] Summary: what to do about INET/CIDR

2000-10-28 Thread Dominic J. Eidson
dvanced - like for storing subnets on non-octet boundaries etc, and have host(), broadcast(), network(), and netmask() functions. host() would return the IP with a /32 mask - and inet(cidr) would just return the IP, without a mask. > I'm

[HACKERS] Re: [GENERAL] Great Bridge is hiring!

2000-10-23 Thread Dominic J. Eidson
On Mon, 23 Oct 2000, Ned Lilly wrote: > Date: Mon, 23 Oct 2000 10:53:48 -0400 > From: Ned Lilly <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: [GENERAL] Great Bridge is hiring! But for what? :) -- Dominic J. Eidson

Re: [HACKERS] getting local domain to get attached through sendmail...

2000-10-15 Thread Dominic J. Eidson
omain')' to my m4 config file, but > that doesn't appear to be helping, but figure it probably somethign really > obvious :( Hack^H^H^H^HEdit the commit script to use sendmail -f [EMAIL PROTECTED]? -- D

[HACKERS] On the subject of yacc...

2000-10-01 Thread Dominic J. Eidson
rver1:/tmp/pgsql > rpm -q -a | grep 'yacc' yacc-91.7.30-167 Just a FYI on another distrib that might cause "problems" ... -- Dominic J. Eidson "Baruk

pgsql-hackers@postgresql.org

2000-09-24 Thread Dominic J. Eidson
the above cases - in the final case, > probably also generate a NOTICE. In these cases, is NULL = 0? - What if it returns the UID for "root" (typically UID 0)... I think an error message should/would be better in this case. Just my $.02. -- Dominic J. Eidson