.
The triggers might use subtransactions. You get implicit subtransactions
if have an EXCEPTION clause in a plpgsql function. I'm not sure if
there's other things that do that as well.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
cuting the long running query, and
then use pg_cancel_backend (or kill -INT) to cancel it.
and also tell me how to log slow queries to a log file.
Using the log_min_duration_statement configuration variable.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---
corrupted data in that table for some
reason, perhaps bad hardware? I bet that a simple "SELECT * FROM
atbs2_logs" will fail as well.
Which server version is this exactly? 8.1.what?
How far did the pg_dump get before the crash? Is there any output at all?
--
Heikki
sing
libpqwalreceiver to be built with wrong flags? Does contrib/dblink work?
If you look at the build log, what is the command line used to compile
libpqwalreceiver, and what is the command line used to build other
libraries, like contrib/dblink?
--
Heikki Linnakangas
EnterpriseDB http://w
x27;ll likely need to go back and forth a few times with various
debugging patches until we get to the heart of this..
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
diff --git a/src/backend/commands/vacuumlazy.c b/src/backend/commands/vacuumlazy.c
index 67e0be9..0e88aa
On 28.02.2011 23:28, daveg wrote:
On Wed, Jan 12, 2011 at 10:46:14AM +0200, Heikki Linnakangas wrote:
We'll likely need to go back and forth a few times with various
debugging patches until we get to the heart of this..
Anything new on this? I'm seeing at on one of my clients produc
, so
an incorrectly set flag won't affect correctness of query results, but
the flag is still set as usual and you still get the warnings so that we
can continue to debug the issue.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
diff --git a/src/backend/access/heap/hea
On 09.01.2013 20:28, Lonni J Friedman wrote:
Greetings,
I'm running postgres-9.2.2 in a Linux-x86_64 cluster with 1 master and
several hot standby servers. Since upgrading to 9.2.2 from 9.1.x a
few months ago, I switched from generating a base backup on the
master, to generating it on a dedicate
On 12.01.2013 04:32, Phil Monroe wrote:
Hi Everyone,
So we had to failover and do a full base backup to get our slave database back
online and ran into a interesting scenario. After copying the data directory,
setting up the recovery.conf, and starting the slave database, the database
crashes wh
On 26.01.2013 01:28, Lonni J Friedman wrote:
On Tue, Jan 15, 2013 at 2:57 AM, Heikki Linnakangas
wrote:
That process sounds correct. Since you're using pg_basebackup -x option, you
don't even need to copy the WAL logs, although it shouldn't do any harm
either . The tar file
On 29.01.2013 18:36, Lonni J Friedman wrote:
On Tue, Jan 29, 2013 at 8:32 AM, Heikki Linnakangas
wrote:
Thanks. I'm afraid I didn't get any wiser from the log output. Since this is
a test system, could you reduce the test case into something smaller and
self-contained?
Sorr
11 matches
Mail list logo