Re: [PERFORM] rapid degradation after postmaster restart

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: <mail(at)joeconway(dot)com>
Cc: <matthew(at)zeut(dot)net>, <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>, <josh(at)agliodbs(dot)com>
Subject: Re: [PERFORM] rapid degradation after postmaster restart
Date: 2004-03-16 15:50:06
Message-ID: 12158.192.154.91.225.1079452206.squirrel@matth.zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

> [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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-03-16 15:55:27 Re: WAL write of full pages
Previous Message Tom Lane 2004-03-16 15:36:38 Re: WAL write of full pages

Browse pgsql-performance by date

  From Date Subject
Next Message Rosser Schwarz 2004-03-16 17:32:56 Re: atrocious update performance
Previous Message Tom Lane 2004-03-16 15:25:35 Re: atrocious update performance