PgSql
in [SQL]
|
[HACKERS] system views for walsender activity Hi, We don't have any statistic views for walsenders in SR's master server in 9.0, but such views would be useful to monitor and manage standby servers from the master server. I have two ideas for the solution - adding a new system view or recycling pg_stat_activity: 1. Add another system view for walsenders, ... 17 Jun 2010 23:22
Why aren't master and slave DBs binary identical? Hi, On Friday 18 June 2010 00:22:00 Josh Berkus wrote: We've noticed that checksums and file sizes for the master database, and slave database, even after all transactions have been cleared, are not identical. Why is that? Non Wal-Logged action like visibility bits. Andres -- Sent via pgsql-hacker... 17 Jun 2010 20:06
trace_recovery_messages Fujii Masao <masao.fujii(a)gmail.com> writes: We should make trace_recovery_messages available only when the WAL_DEBUG macro was defined? No, because it's used in a lot of other contexts besides that. Currently it's always available, so the standby seems to call elog() too frequently. Where? I don't ... 18 Jun 2010 11:19
Debug message in RemoveOldXlogFiles Fujii Masao <masao.fujii(a)gmail.com> writes: In the following debug message in RemoveOldXlogFiles(), the variables "log" and "seg" don't indicate LSN, so we should use %u instead of %X? elog(DEBUG2, "removing WAL segments older than %X/%X", log, seg); I attached the patch to do so. Applied, thanks. ... 18 Jun 2010 10:13
modular se-pgsql as proof-of-concept 2010/6/17 KaiGai Kohei <kaigai(a)ak.jp.nec.com>: I tried to implement a modular se-pgsql as proof-of-concept, using the DML permission check hook which was proposed by Robert Haas. At first, please build and install the latest PostgreSQL with this patch to add a hook on DML permission checks. �http://ar... 17 Jun 2010 23:22
ANNOUNCE list (was Re: [HACKERS] New PGXNExtension site) On Thu, 2010-06-17 at 13:22 +0000, Greg Sabino Mullane wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 What I'm referring to? The fact that at least last time I was looking at this, most (all other?) moderators *only* approve things. And never reject them, instead letting the time... 17 Jun 2010 13:25
ANNOUNCE list (was Re: New PGXN Extension site) Marc Fournier wrote: But, I think you and I are exceptions here, in that we use the web interface for moderation, and not just email ... Is it possible that the ones that use email for moderating the lists have aggressive spam filters? Then they might not receive most of the list postings that should be rejected�... 17 Jun 2010 13:25
DB crash SOS On Jun 17, 2010, at 10:39 , Felde Norbert wrote: I tried even with a bigger empty clog/0003 file but than I get that: pg_dump: Error message from server: ERROR: xlog flush request 0/A19F5BF8 is not satisfied --- flushed only to 0/A02A1AC8 CONTEXT: writing block 1149 of relation 1663/4192208/4192508 pg_... 17 Jun 2010 15:38
[HACKERS] pg_dump does not honor namespaces when functions are used in index Dear hackers, I have a pretty nasty problem to submit to your careful scrutiny. Please consider the following piece of SQL code: CREATE SCHEMA bar; SET search_path = bar; CREATE FUNCTION bar() RETURNS text AS $$ BEGIN RETURN 'foobar'; END $$ LANGUAGE plpgsql IMMUTABLE; CREATE SCHEMA foo; SET ... 17 Jun 2010 11:09
pg_dump does not honor namespaces when functions are used in index On 17 June 2010 12:31, Jean-Baptiste Quenot <jbq(a)caraldi.com> wrote: Dear hackers, I have a pretty nasty problem to submit to your careful scrutiny. Please consider the following piece of SQL code: CREATE SCHEMA bar; SET search_path = bar; CREATE FUNCTION bar() RETURNS text AS $$ B... 18 Jun 2010 09:07 |