PgSql

don't allow walsender to consume superuser_reserved_connection slots, or during shutdown
Robert Haas <robertmhaas(a)gmail.com> writes: Here's the fine patch. The actual code changes are simple and seem to work as expected, but I struggled a bit with the phrasing of the messages. Feel free to suggest improvements. Stick with the original wording? I don't really see a need to change it. re... 26 Apr 2010 06:57

vcregress.bat check triggered Heap error in the Debugversion of win32 build
Xiong He wrote: When I build the debug version of PostgreSQL (latest code), I found that I always failed to run the vcregress.bat check. It always pops up the following error. The release version can pass the test without any error. Anyone met such error? [graphic deleted] Pleas... 23 Apr 2010 21:20

[COMMITTERS] pgsql: Add missing optimizer hooks for function cost and number of rows.
On Fri, Apr 23, 2010 at 6:55 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: sriggs(a)postgresql.org (Simon Riggs) writes: Log Message: ----------- Add missing optimizer hooks for function cost and number of rows. Closely follow design of other optimizer hooks: if hook exists retrieve value from plugin; if... 23 Apr 2010 21:20

[HACKERS] libpq connectoin redirect
Hi, I want to load balance a postgres server on 4 physical machines, say 127.0.0.11-14. I can set up a pgbouncer on 127.0.0.10 and connection pooling to my four boxes. However, the traffic from/to clients will go through an extra hop. Another way to do this, is to send the client an "redirect" message. When cl... 23 Apr 2010 21:20

Should database = all in pg_hba.conf match areplication connection?
On Tue, 2010-04-20 at 19:06 -0400, Tom Lane wrote: Should we change this? It seems to me to be a good thing on security grounds if replication connections can't be made through a generic pg_hba entry. That's a good change. -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hacker... 23 Apr 2010 21:20

psql: Add setting to make '+' on \d implicit
On Apr 23, 2010, at 11:28 AM, Tom Lane wrote: "Ross J. Reedstrom" <reedstrm(a)rice.edu> writes: On Fri, Apr 23, 2010 at 10:58:40AM -0500, Terry Brown wrote: So the proposal would be: \d+ does as it has always done, no change \d- (new) always behaves like 'old' \d \d acts as 'old' \d ... 25 Apr 2010 06:35

pgsql: Make CheckRequiredParameterValues() dependupon correct
On Fri, 2010-04-23 at 16:04 -0400, Tom Lane wrote: sriggs(a)postgresql.org (Simon Riggs) writes: Log Message: ----------- Make CheckRequiredParameterValues() depend upon correct combination of parameters. Fix bug report by Robert Haas that error message and hint was incorrect if wrong mode par... 23 Apr 2010 17:53

recovery_connections cannot start (was Re: [HACKERS] master instandby mode croaks)
Tom Lane wrote: Robert Haas <robertmhaas(a)gmail.com> writes: ... I'm still unconvinced of our ability to come up with a solid design in the time we have, but I think it would make sense to listen to proposals people want to make. I poked some holes in Heikki's design from this morning (which was, mo... 26 Apr 2010 14:55

Move tablespace
Simon Riggs <simon(a)2ndQuadrant.com> writes: Following patch writes a new WAL record that just says "copy foo to newts" and during replay we flush buffers and then re-execute the copy (but only when InArchiveRecovery). So the copy happens locally on the standby, not copying from primary to standby. We do thi... 23 Apr 2010 21:20

Should database = all in pg_hba.conf match a replication connection?
On Apr 20, 2010, at 7:06 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: I spent a fair amount of time just now being confused about why pg_hba.conf restrictions on replication connections didn't seem to be getting enforced. After looking at the code, I realize that my entry with database = "replication" was indee... 21 Apr 2010 00:06