PgSql

[HACKERS] Row-level Locks & SERIALIZABLE transactions, postgres vs. Oracle
Hi After the recent discussion about the impossibility of efficiently implementing FK-like constraint triggers in PL/PGSQL that work correctly under SERIALIZABLe transactions, I've compared our behavior to that of Oracle. As it turns out, a slight difference in Oracle's behavior makes those FK constraint triggers wh... 13 May 2010 18:17

[HACKERS] quoting and recovery.conf
Is there a reason we require single quotes around boolean values in recovery.conf? standby_mode = 'off' This does not work: standby_mode = off I knew there were inconsistencies between quoting in postgresql.conf and recovery.conf, but I didn't realize it extended to boolean quoting. I see this at the ... 13 May 2010 13:49

[HACKERS] wal_level and continuous archiving documentation
I was reading through http://www.postgresql.org/docs/9.0/static/continuous-archiving.html and noticed that wal_level isn't mentioned where I'd expect it to be. Specifically, there's a paragraph that starts, "To enable WAL archiving, set the archive_mode configuration parameter to on, and specify the shell command ... 13 May 2010 13:49

wal_level in postgresql.conf
Bruce Momjian wrote: Why is 'wal_level' listed next to 'fsync' in postgresql.conf? #wal_level = 'hot_standby' # minimal, archive, or hot_standby #fsync = on # turns forced synchronization on or off #synchronous_commit = on # immediate fsync at c... 14 May 2010 03:01

[HACKERS] wal_mode in postgresql.conf
Why is 'wal_level' listed next to 'fsync' in postgresql.conf? #wal_level = 'hot_standby' # minimal, archive, or hot_standby #fsync = on # turns forced synchronization on or off #synchronous_commit = on # immediate fsync at commit #wal_sync_method = fsync... 13 May 2010 11:36

make install fails due to "/bin/mkdir: missingoperand"
On mån, 2010-05-10 at 20:07 +0900, Kenichiro Tanaka wrote: Reproduce case: #prefix and with-pgport are not important ./configure --enable-nls='UFT_JP' --prefix=/home/p900/posgrehome --with-pgport=1900 make && make install make install log---------------------------------------------------------... 13 May 2010 11:36

pgsql: Add PGFILEDESC description to Makefiles for all /contrib
On Thu, May 13, 2010 at 1:47 AM, Bruce Momjian <bruce(a)momjian.us> wrote: bruce wrote: Tom Lane wrote: Bruce Momjian <bruce(a)momjian.us> writes: All other binaries had such a designation, and all /contrib binaries were missing them.  I assume I was doing cleanup.  You want the icon re... 13 May 2010 07:11

How to know killed by pg_terminate_backend
Tatsuo Ishii wrote: If a backend killed by pg_terminate_backend(), the backend returns 57P01 which is identical to the one when it's killed by postmaster. Problem is, pgpool-II needs to trigger failover if postmaster goes down because apparently pgpool-II cannot use the PostgreSQL server anymore. ... 15 May 2010 09:21

pg_upgrade code questions
On Thu, 2010-05-13 at 15:13 +0900, Takahiro Itagaki wrote: ==== 4. EDB_NATIVE_LANG ==== Of course it is commented out with #ifdef, but do we have codes for EDB in core? I was about to raise similar thing, for the documentation: http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html This includ... 15 May 2010 04:01

Stefan's bug (was: max_standby_delay considered harmful)
Excerpts from Robert Haas's message of mié may 12 20:48:41 -0400 2010: On Wed, May 12, 2010 at 3:55 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: I am wondering if we are not correctly handling the case where we get a shutdown request while we are still in the PM_STARTUP state.  It looks like we migh... 26 May 2010 22:27