PgSql

Archive recovery crashes on win32 in HEAD - hot standby related?
On Sat, Jan 16, 2010 at 8:19 AM, Magnus Hagander <magnus(a)hagander.net> wrote: Not knowing that code very well at this time, but is this perhaps a structure not being properly initialized in EXEC_BACKEND case? It looks like KnownAssignedXidsHash is not initialized. That's supposed to happen when CreateSharedP... 17 Jan 2010 08:20

Mammoth in Core?
"Joshua D. Drake" <jd(a)commandprompt.com> writes: O.k. I know there is no way we will hit this for 8.5. So this is more of a future discussion more than anything. Well, this is not really the time to be having such a discussion; right now we need to all have our noses to the grindstone dealing with the alread... 6 Feb 2010 07:29

Hot Standby and handling max_standby_delay
Simon Riggs wrote: We need to calculate a more accurate time since WAL arrived to make max_standby_delay sensible in all cases. Difficult to know exactly when to record new timestamps for received WAL. So, proposal is... if (Base time is earlier than WAL record time) standby_delay = WAL record time ... 18 Jan 2010 13:09

[HACKERS] Hot Standby and handling max_standby_delay
We need to calculate a more accurate time since WAL arrived to make max_standby_delay sensible in all cases. Difficult to know exactly when to record new timestamps for received WAL. So, proposal is... if (Base time is earlier than WAL record time) standby_delay = WAL record time - Base time else standby_dela... 15 Jan 2010 13:50

[HACKERS] ECPG documentation patch
Hi, here's the documentation patch for the new ECPG features. - I changed the order of sections "Using Descriptor Areas" and "Informix compatibility mode" - split the "Using Descriptor Areas", so it now have two subsections: "Named SQL Descriptor Areas" and "SQLDA Descriptor Areas". The second one talks... 15 Jan 2010 13:50

New XLOG record indicating WAL-skipping
Fujii Masao wrote: On Wed, Dec 9, 2009 at 6:25 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: Here is the patch: - Write an XLOG UNLOGGED record in WAL if WAL-logging is skipped for only the reason that WAL archiving is not enabled and such record has not been written yet. - Cause archi... 18 Jan 2010 08:38

[HACKERS] missing data in information_schema grant_* tables?
Hello pgdevs, I'm trying to use the information_schema, and I'm looking at the grant tables. ISTM that some views do not show all expected permissions. psql> CREATE TABLE foo(); psql> CREATE USER calvin NOLOGIN; psql> GRANT SELECT ON TABLE foo TO calvin; psql> GRANT INSERT ON TABLE foo TO PUBLIC; --... 15 Jan 2010 07:09

Streaming replication, loose ends
Heikki Linnakangas wrote: I've now committed streaming replication. I moved the files around a bit, and put the walreceiver/walsender stuff in a new src/backend/replication subdirectory. There's enough stuff there already to deserve a new subdirectory, and if we add the capability for streaming base back... 15 Jan 2010 22:44

attoptions
On Sun, Jan 10, 2010 at 12:27, Robert Haas <robertmhaas(a)gmail.com> wrote: I am not very happy with ATPrepSetOptions().  I basically just retained the logic from ATPrepSetDistinct(), but it doesn't really make sense in this context.  The idea that we want to support attdistinct for system tables and index ... 22 Jan 2010 14:05

PG_MODULE_MAGIC checks and pg_migrator
Bruce Momjian <bruce(a)momjian.us> writes: For example, right now pg_migrator can migrate to 8.4 and 8.5, but there is no way to distribute a binary that will migrate to both because you need different shared libraries with different PG_MODULE_MAGIC values. [ yawn... ] By the time 8.5 (9.0?) ships, this will... 16 Jan 2010 07:19