On 26.01.2013 01:28, Lonni J Friedman wrote:
On Tue, Jan 15, 2013 at 2:57 AM, Heikki Linnakangas
hlinnakan...@vmware.com 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
On 29.01.2013 18:36, Lonni J Friedman wrote:
On Tue, Jan 29, 2013 at 8:32 AM, Heikki Linnakangas
hlinnakan...@vmware.com 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
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
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
it, 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/heapam.c
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 production boxes
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..0e88aa5 100644
--- a/src/backend/commands/vacuumlazy.c
+++ b/src/backend
, and what is the command line used to build other
libraries, like contrib/dblink?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
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 Linnakangas
EnterpriseDB http://www.enterprisedb.com
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
---(end
.
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
---(end of broadcast
11 matches
Mail list logo