X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5C275D1B91B for ; Tue, 16 Mar 2004 15:50:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 12289-05 for ; Tue, 16 Mar 2004 11:50:25 -0400 (AST) Received: from dezeut.zeut.net (ool-4352919e.dyn.optonline.net [67.82.145.158]) by svr1.postgresql.org (Postfix) with ESMTP id B5605D1E2CA for ; Tue, 16 Mar 2004 11:50:20 -0400 (AST) Received: from dezeut.zeut.net (localhost.localdomain [127.0.0.1]) by dezeut.zeut.net (8.12.8/8.12.8) with ESMTP id i2GFo7TH026955; Tue, 16 Mar 2004 10:50:07 -0500 Received: (from apache@localhost) by dezeut.zeut.net (8.12.8/8.12.8/Submit) id i2GFo69o026953; Tue, 16 Mar 2004 10:50:06 -0500 X-Authentication-Warning: dezeut.zeut.net: apache set sender to matthew@zeut.net using -f Received: from 192.154.91.225 (SquirrelMail authenticated user dbmailtest) by matth.zeut.net with HTTP; Tue, 16 Mar 2004 10:50:06 -0500 (EST) Message-ID: <12158.192.154.91.225.1079452206.squirrel@matth.zeut.net> Date: Tue, 16 Mar 2004 10:50:06 -0500 (EST) Subject: Re: [PERFORM] rapid degradation after postmaster restart From: "Matthew T. O'Connor" To: In-Reply-To: <4056A8A7.4060208@joeconway.com> References: <4052661D.5060505@joeconway.com> <14884.1079150555@sss.pgh.pa.us> <4055F343.6070600@joeconway.com> <405614CA.5030101@zeut.net> <405689A4.4080406@joeconway.com> <4056916B.5090204@zeut.net> <4056A8A7.4060208@joeconway.com> X-Priority: 3 Importance: Normal Cc: , , , X-Mailer: SquirrelMail (version 1.2.11) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.4 tagged_above=0.0 required=5.0 tests=BAYES_00, RCVD_IN_DYNABLOCK, RCVD_IN_NJABL, RCVD_IN_NJABL_DIALUP, RCVD_IN_SORBS X-Spam-Level: * X-Archive-Number: 200403/725 X-Sequence-Number: 51317 > [moving to hackers] > > Line 681 is this: > sprintf(logbuffer, "dbname: %s Username %s Passwd %s", > dbi->dbname, dbi->username, dbi->password); > > It appears that dbi->password is a null pointer: > (gdb) print dbi->dbname > $1 = 0x25f68 "template1" > (gdb) print dbi->username > $2 = 0x25b20 "dba" > (gdb) print dbi->password > $3 = 0x0 > > Problem is, since this is a development machine, they have everything > set to "trust" in pg_hba.conf. I added a "-P foo" to the command line, > and it starts up fine now. Ok, that is about what I figured the problem would be. I will try to take a look at this soon and submit a patch. However since you can work around it now, can you do another test run with -d2? Thanks for tracking this down. Matthew