From: Ward Eaton <Ward.Eaton@rad-con.com>
To: pgsql-admin@postgresql.org
Subject: PostgreSQL Database freezes during backup then generates drwtsn.exe process
Date: Tue, 2 Dec 2008 09:01:29 -0500
Message-ID: <04A6DB42D2BA534FAC77B90562A6A03DB91F47@server.rad-con.local> (raw)
I'm running PostgreSQL 8.3 on a Windows 2003 machine (pgAgent service is
also installed and running). The system is running as a redundant
database server. Thus, backing up from one machine to another, and
transferring over WAL logs. In the postageSQL log files there are
several error messages that read:
'could not rename file, no such file or directory'
Eventually, postgreSQL 'freezes', I'm unable to access the database, and
there is no logging. I find a drwtsn.exe process running under the
postgres account in Task Manager. If I kill the drwtsn PostgreSQL
service will stop. I can then restart it and the database will run as
expected for a few days.
Has anyone encountered this problem before? If so, were you able to
find a solution?
Thanks for any help in advance.
Ward Eaton
Project Engineer Automation
RAD-CON Inc.
TECHNOLOGY: Innovative & Proven
Office: +1.216.706.8927
Fax: +1.216.221.1135
Website: www.RAD-CON.com <http://www.rad-con.com/;
E-mail: Ward.Eaton@RAD-CON.com <mailto:Ward.Eaton@RAD-CON.com>
Attachments:image002.jpg (image/jpeg, 2.8K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Ward.Eaton@rad-con.com
Subject: Re: PostgreSQL Database freezes during backup then generates drwtsn.exe process
In-Reply-To: <04A6DB42D2BA534FAC77B90562A6A03DB91F47@server.rad-con.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox