Skip site navigation (1) Skip section navigation (2)

Re: does wal archiving block the current client connection?

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: does wal archiving block the current client connection?
Date: 2006-05-19 16:41:40
Message-ID: 1148056900.2646.687.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
On Fri, 2006-05-19 at 09:36 -0700, Jeff Frost wrote:
> On Fri, 19 May 2006, Tom Lane wrote:
> 
> > What I'd suggest is resuming the test after making sure you've killed
> > off any old archivers, and seeing if you can make any progress on
> > reproducing the original problem.  We definitely need a
> > multiple-archiver interlock, but I think that must be unrelated to your
> > real problem.
> 
> Ok, so I've got the old archivers gone (and btw, after a restart I ended up 
> with 3 of them - so I stopped postmaster, and killed them all individually and 
> started postmaster again).  

Thats good.

> Now I can run my same pg_bench, or do you guys 
> have any other suggestions on attempting to reproduce the problem?

No. We're back on track to try to reproduce the original error.

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com


In response to

Responses

pgsql-hackers by date

Next:From: Mike EllsworthDate: 2006-05-19 16:42:49
Subject: Re: [HACKERS] Toward A Positive Marketing Approach.
Previous:From: Jeff FrostDate: 2006-05-19 16:36:47
Subject: Re: does wal archiving block the current client connection?

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2006-05-19 20:00:57
Subject: Re: query optimization - mysql vs postgresql
Previous:From: Jeff FrostDate: 2006-05-19 16:36:47
Subject: Re: does wal archiving block the current client connection?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group