Re: does wal archiving block the current client connection?

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: does wal archiving block the current client connection?
Date: 2006-05-15 21:39:16
Message-ID: 1147729156.9755.154.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

On Mon, 2006-05-15 at 16:29, Jeff Frost wrote:
> On Mon, 15 May 2006, Simon Riggs wrote:
>
> > On Mon, 2006-05-15 at 09:28 -0700, Jeff Frost wrote:
> >> I've run into a problem with a PITR setup at a client. The problem is that
> >> whenever the CIFS NAS device that we're mounting at /mnt/pgbackup has
> >> problems
> >
> > What kind of problems?
>
> It becomes unwritable for whatever reason CIFS shares become unwritable. It's
> a windows 2003 NAS device and a reboot solves the problem, but it leaves no
> event logs on the windows side of things, so difficult to determine the root
> cause.

I don't think you need logs to figure out that the problem is that it's
a Windows based NAS device. :)

Seriously, we had BSD based NAS devices one place I worked, and the
company making them switched to Win2k3 and after we had one or two do
exactly what you're talking about, we just started building our own
based on RedHat or BSD. Same hardware (we just formatted the drives on
one of the ones that came with w2k3) and we never had another moment's
problem with them.

In other news... Does the archiver actually connect to the database?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2006-05-15 22:46:32 Re: does wal archiving block the current client connection?
Previous Message Jeff Frost 2006-05-15 21:29:57 Re: does wal archiving block the current client connection?

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2006-05-15 22:12:10 Re: [HACKERS] Iterating generator from C (PostgreSQL's
Previous Message Jeff Frost 2006-05-15 21:29:57 Re: does wal archiving block the current client connection?