Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 21BD564FE2D for ; Tue, 2 Dec 2008 10:08:26 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05356-05 for ; Tue, 2 Dec 2008 10:08:20 -0400 (AST) X-Greylist: delayed 00:06:35.346182 by SQLgrey-1.7.6 Received: from svr-grp1-mail.brickcitywebs.net (svr-grp1-mail.brickcitywebs.net [209.208.74.172]) by mail.postgresql.org (Postfix) with ESMTP id 7AB5C64FE01 for ; Tue, 2 Dec 2008 10:08:20 -0400 (AST) Received: (qmail 1207 invoked from network); 2 Dec 2008 07:49:18 -0500 Received: from svr-grp1-mail.brickcitywebs.net (HELO outlook.rad-con.com) (12.49.144.162) by svr-grp1-mail.brickcitywebs.net with SMTP; 2 Dec 2008 07:49:18 -0500 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/related; type="multipart/alternative"; boundary="----_=_NextPart_001_01C95486.7972ECE5" X-MimeOLE: Produced By Microsoft Exchange V6.5 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> X-MS-Has-Attach: yes X-MS-TNEF-Correlator: Thread-Topic: PostgreSQL Database freezes during backup then generates drwtsn.exe process thread-index: AclUhnkhTJruGaN9S8KYgU2jFK4wAA== From: "Ward Eaton" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.001 tagged_above=0 required=5 tests=EXTRA_MPART_TYPE=1, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200812/11 X-Sequence-Number: 30844 This is a multi-part message in MIME format. ------_=_NextPart_001_01C95486.7972ECE5 Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C95486.7972ECE5" ------_=_NextPart_002_01C95486.7972ECE5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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' =20 =20 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. =20 =20 Has anyone encountered this problem before? If so, were you able to find a solution? =20 Thanks for any help in advance. =20 Ward Eaton Project Engineer Automation =20 RAD-CON Inc. TECHNOLOGY: Innovative & Proven Office: +1.216.706.8927 Fax: +1.216.221.1135 Website: www.RAD-CON.com =20 E-mail: Ward.Eaton@RAD-CON.com =20 =20 ------_=_NextPart_002_01C95486.7972ECE5 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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
E-mail: = Ward.Eaton@RAD-CON.com

------_=_NextPart_002_01C95486.7972ECE5-- ------_=_NextPart_001_01C95486.7972ECE5 Content-Type: image/jpeg; name="image002.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Description: image002.jpg Content-Location: image002.jpg /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7 Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCAAuAIwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD0Pxb4 mj8M2a3EhJaT5IYgMmWTsvt9awx4q8akD/ilUHH/AD9r/hVf4vcWukf9fq/yNb979s+wS/2eYhd7 P3JmGU3e/tQbJRjBSavcw7rxn4ws7Z7ibwsPLQZYrchiB64ArHh+Luq3M6Qw6PEzyMFQef1J/wCA 12GlHUI7IHV5bY3CsSzW6kIF/H9a8x8M21vqXxBL2oBtEuZZkwONoJxj2oOvDwo1FLmjsr7naT+M fGUETyyeHI1SNSzH7SOABk9qztO+J3iHV5jFY6NDK6pvI88Dj8q7GSEOCjDKuCD9DXm3gG0Np4ov 7N1wYEdMfRsfyxQZ0Y0pwm3HVK+508njTxnEhZvDcbAdlnBP8qyW+MGrROUk0eJWU4KtKQR+G2t3 VfEGnaLf2tnd+arXQyrqmVXnHP41kePtBjutOTUYY1F1FKkbN03oxxz9CRQFB0pSSqR0ZCPjHqXf SIT/ANt//sacnxj1FmCLokbMxwAJzk/+O1zn/CA+I84+xp/3+Wup+HXh1bSS8vL2JftcM5t1Bwdh HXHvz1oO+rRwUIOS1+Zpw+NvF80fmR+DZGXHebH6baz734q61p0gjvvDJt3PQSzFc/T5a1tQ+I2g 6XqcthKbqaSFtsrwx7lRu4znnHtVG9m0bx74l0RbW5+02trHNLcRkFSPu7QQfU0HDCML3nT935k2 neO/FWrQCey8JmSE9HNxtB+mV5qlqPxR13SZ/Jv/AA0bZz0Ek/X6Hbg10viLxbpPhNLeK6WV5JR+ 6t7dAWCDv1AAp9xFpfjbwwSmJre5QmJiMPG46H2INBEXTvzOHumPZ+M/F+oWkV3aeFElhmGUcXYw R69Ko2PxN8Q6nqE2nWfhpZLqDPmRG5wVwcHqPWui8FIy+DtMRxh1iKsPQhiD/Kol8PLbeOzrtuoE d5bNHcD0kBGG/EUEN0uZq3oVLfx1qkeqxabrumDSprqNmtT5nmiRh2OBxXUeHNRm1bw9Y39xhZZ4 g7hRxmuA8b/8lC8MYP8AC/8A6Ea7fwP/AMiXpX/XAfzNBlJKyfc5X4wnFlpB/wCn1f5GtDxRdXFl 4Tv7q1laGeKDcki9VORyKzPjMWGm6WVOG+1jBPY4NQXug+MdTsJLG616ya3nXa6i0wcemaDWKvCN 31NTwZrF1regJdXu1p0kaNmUY347ketY/g3TIrXxb4haFcR28phjH90Md1O0rwx4p0ezFrp+t2kU RYtta1L8n3NSWXhvxXYz3c9tr1msl5L5szGzzubGPwFBtJxjKfI1ZnUJcStqFxbG2kWOFEZZiMLI TnIH04rk9Mtmg+KGsDHEtuJV9wdtOg8LeLYNTl1BPEkZuJs7t8TFOfRDwOnanf8ACO+LBqh1Qa7a famh8nf9k42ZzjFBEI8t1zLVGhrHha11rVLS8upZALVSBEoGH5zyazfiBq0dhoyWishu7mVGRD2R W3FiPTgCp303xs6Ff+EjtVz/ABLZjIrAm+HGq3Fw9xc6ss88n3pJFZmNBVGMHKKqzXKjP/4WL4iz n/Qf+/B/xrofh/4hN7JfWt06C7mna5VV4DZxnA9sdKyD8Nr4f8xCHr/zzakT4e38ciumpRo6HKsi MCD7Gg76scDKDUHZnR33w70u/wBTmvPtk8IncyPGoBG49SCaiki0jwF4j0doA0cF4ksNzLI2T/Dt Y+wNMh0/xhDGEXxJEwHeS33H86oaj4N17WJUk1HXluWjBCBoyAoPXAH0oOSE5StCpU9067xN4Qsf FMlvcTXEkE0K7VliwwdDzj/A1cB07wf4bJEgis7OMkFzyzf1JNcppnh/xdpVsLex8RRCAfcjlgMg X6Z6VV1XwP4l1x1bU/ECXOzlEMbBE+ijj8aDG17U3P3UdX4Olkk8GadI7fO8TOx9yxP8zTPCviQe I9ES5JAuYmMdwgP3WHf6Ec1xt7ceK/CcdvpUWr2zQx2ckyAW3RUPI5781j2NvrHhW6lltdTjiSfe ryJCZQwTaSQvrlsY7c07E+yi7u/odN4zb/ivfDZz0R+/+1Xe+B/+RK0r/r3H8zXi8Orapq3jLTjq cwma2laONhD5YI78V7T4H/5EvSv+vcUMirFxUUzj/jWT/ZGnYB4uckjtwa8rj1bUS4DaleY/6+G/ xr33xdpV/qdusVqtlJFIpjmS6LDIPoVrjB8OZx/zDNF4/wCm09Ctaxvh68IK01c89/tHUB01K8/8 CH/xq7b3F3Jp087ajfs8efu3ZUIMZyQTzk8cV2//AAr67/6Bui/9/p6P+FfXJPOmaIcdP3s9I7Z4 zDSVows/RHKxwXf2+eJ9T1B40t/Nh2XhDTHC8A59SR+FQK0rWFrOdZvVknnEBi+1ElDuO4nnoFxg +prsj8Pp/wDoE6H/AN/Z/wDCgfD+4B/5Beif9/p6DD6zR7fgjkLuG9R74W9/qGbZl2K95kyLkgv1 6YFKsMgksBLr11ifi623RJhO3cO/p+tdd/wr6bGP7I0P/v8AT/4UH4f3OMf2XomP+us9AfWqVrW/ BHIvCUguXOt3biKNGEgujt5QtkjOTyAMdcmq8KXDWUstzqN5HKoLEfaSBGNm4EgnJ3dBiu1/4V7c /wDQL0T1/wBbP/hTT8PLtuTp+iZPrLN/hQL6zTSa/RHGXIMPmeXrFyxSLf8A69vlOEODzz949PSp JkdL+3gGrXipKzqS11nIH3XGDwGPrXXH4d3v/Pjov/fyb/Ck/wCFdXmTix0UZ6/vJuf0oBYmjf8A 4COPgW5OpJbzapfLGUG4pdHO/aCV6+9RW322bVjbza3dQ2iM+6f7WcbVOODn1wK7b/hXN3jB0/RS P+uk3+FH/CuZ++maIf8AtrPTViZYik+n4I80u5NQ8zddXU0h+eIM8xbIB5Gc9KiW8uUkEi3MyurF gwc5BPU/U16gPhzMP+YXonT/AJ7T0v8Awrmf/oGaL/3+nquZFxxVJK3Kee+HGlk8SWG5pH2yluST jOcmvfPA/wDyJWlf9e4rkNP8H6rpLySWFnosDypsZvMmPH4iu38O6dLpPh6x093SRreIIzDOCfap bucdepGpK8VY/9k= ------_=_NextPart_001_01C95486.7972ECE5--