PgSql

krb_server_keyfile setting doesn't work on Windows
Hiroshi Inoue <inoue(a)tpf.co.jp> writes: Because gssapi32.dll(krb5_32.dll) seems to call getenv("KRB5_KTNAME") in msvcr71, postgres.exe should call putenv("KRB5_KTNAME=...") in msvcr71. The attached patch fixes the problem in my test case. Don't we already have something like that in our src/port puten... 6 Jan 2010 09:10

solution to make static changes in pg_hba.conf file?
2009/12/30 Tarun Sharma <tarun.sharma(a)newgen.co.in>: hi, i assigned super user privelledge to a user by specifing entries in pg_hba.conf file as host    all    newuser    127.1.1.1 md5 and the default postgres user is made access to only the default postgres databse and is no more the super user. ... 30 Dec 2009 07:38

[HACKERS] solution to make static changes in pg_hba.conf file?
hi, i assigned super user privelledge to a user by specifing entries in pg_hba.conf file as host all newuser 127.1.1.1 md5 and the default postgres user is made access to only the default postgres databse and is no more the super user. the problem is that this conf file is available to all and ca... 30 Dec 2009 05:28

quoting psql varible as identifier
Pavel Stehule <pavel.stehule(a)gmail.com> writes: so we cannot simply implement quote_ident on client side :(. So we have to use a real query. It is acceptable for you? No, certainly not --- that adds a boatload of failure conditions. Just quote it unconditionally. regards, tom lane -- Sent via ... 2 Feb 2010 16:07

Port for Microsoft Services for Unix (SFU) or SUA
2009/12/28 Josh Rovero <rovero(a)sonalysts.com>: Has anyone built postgresql (or just libpq.a) on Windows SFU/SUA? Would prefer to not reinvent any wheels.... Not that I know of. We have a number of Unix/Linux applications that are also compiled under Microsoft Windows SFU 3.5.  We need to have a SFU-c... 29 Dec 2009 08:34

parse tree to XML format
On Monday 28 December 2009 22:30:44 matt wrote: Is there some way to export the postgresql query parse tree in XML format? I can not locate the API/Tool etc to do that... Thats more of a -general question. There is no such possibility in 8.4 - the not yet released 8.5 contains such a possibility. Andres... 29 Dec 2009 10:47

Time to run initdb is mostly figure-out-the-timezone work
Joshua Tolley <eggyknap(a)gmail.com> writes: On Fri, Dec 18, 2009 at 06:20:39PM +0100, Guillaume Lelarge wrote: Le 18/12/2009 18:07, Tom Lane a �crit : On current Fedora 11, there is a huge difference in initdb time if you have TZ set versus if you don't: I get about 18 seconds versus less than four... 19 Dec 2009 17:06

Buffer statistics for pg_stat_statements
Le vendredi 18 décembre 2009 09:44:40, Takahiro Itagaki a écrit : We have infrastructure to count numbers buffer access in 8.5 Alpha 3. I'd like to add per-query buffer usage into contrib/pg_stat_statements. The pg_stat_statements view will have the same contents with struct BufferUsage. Fields named sh... 7 Jan 2010 20:19

PATCH: Add hstore_to_json()
On Wed, Dec 16, 2009 at 2:28 PM, David E. Wheeler <david(a)kineticode.com> wrote: I just realized that this was easy to do, and despite my complete lack of C skillz was able to throw this together in a couple of hours. It might be handy to some, though the possible downsides are: * No json_to_hstore(). * Lead... 6 Jan 2010 09:09

An example of bugs for Hot Standby
On Tue, 2009-12-15 at 20:25 +0900, Hiroyuki Yamada wrote: Hot Standby node can freeze when startup process calls LockBufferForCleanup(). This bug can be reproduced by the following procedure. Interesting. Looks like this can happen, which is a shame cos I just removed the wait checking code after not ever hav... 21 Jan 2010 05:38