Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 88AE47ACC83 for ; Wed, 8 Aug 2012 12:44:32 -0300 (ADT) Received: from eastrmfepo101.cox.net ([68.230.241.213]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Sz8Qw-0008GS-3b for pgsql-sql@postgresql.org; Wed, 08 Aug 2012 15:44:31 +0000 Received: from eastrmimpo210 ([68.230.241.225]) by eastrmfepo101.cox.net (InterMail vM.8.01.04.00 201-2260-137-20101110) with ESMTP id <20120808154417.BESR18243.eastrmfepo101.cox.net@eastrmimpo210> for ; Wed, 8 Aug 2012 11:44:17 -0400 Received: from slacker.ja10629.home ([68.106.109.147]) by eastrmimpo210 with cox id kFkG1j0183Ar1Vg01FkHEZ; Wed, 08 Aug 2012 11:44:17 -0400 X-CT-Class: Clean X-CT-Score: 0.00 X-CT-RefID: str=0001.0A020202.50228951.00A3,ss=1,re=0.000,fgs=0 X-CT-Spam: 0 X-Authority-Analysis: v=2.0 cv=NNlXCjGg c=1 sm=1 a=sXZhTwfwSKhiTs9RzZXpNQ==:17 a=z1TLwsU0kBEA:10 a=k9yKWX7MKVwA:10 a=PjkiJtDTOQ4A:10 a=ZcFhQy0-F_sA:10 a=kj9zAlcOel0A:10 a=P6M1L9rJAAAA:8 a=VK7F--vOW1w8rdEY27sA:9 a=CjuIK1q_8ugA:10 a=sXZhTwfwSKhiTs9RzZXpNQ==:117 X-CM-Score: 0.00 Authentication-Results: cox.net; none Received: from wcuddy by slacker.ja10629.home with local (Exim 4.72) (envelope-from ) id 1Sz8Qi-0008HW-Rr for pgsql-sql@postgresql.org; Wed, 08 Aug 2012 11:44:16 -0400 Date: Wed, 8 Aug 2012 11:44:16 -0400 From: Wayne Cuddy To: PostgreSQL Subject: fsync debug messages in pgsql logs Message-ID: <20120808154416.GE16371@slacker.ja10629.home> Mail-Followup-To: PostgreSQL Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.3i X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/9 X-Sequence-Number: 36780 I'm seeing this in my PGSQL logs, is this something to be concerned about? I know the file system it sits on is reliable and the DB appears to run with fine, additionally the log indicates it's a debug message. I did some google searches and didn't find much. When I examine the file system file by these names to not exist. Thanks, Wayne ---------------------------------------------------------------------- 2012-07-19 21:05:42.840 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/45365979_fsm" but retrying: No such file or directory 2012-07-20 06:25:43.899 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/45413298_fsm" but retrying: No such file or directory 2012-07-20 11:20:44.755 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/45438221_fsm" but retrying: No such file or directory 2012-07-20 15:40:45.974 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/45460199_fsm" but retrying: No such file or directory 2012-07-22 12:35:43.882 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/45687933_fsm" but retrying: No such file or directory 2012-07-25 03:35:42.933 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/46007387_fsm" but retrying: No such file or directory 2012-07-25 06:30:45.354 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/46022167_fsm" but retrying: No such file or directory 2012-07-26 06:48:13.595 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/46145719_fsm" but retrying: No such file or directory 2012-07-28 17:58:40.774 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/46445945_fsm" but retrying: No such file or directory 2012-08-01 09:38:42.234 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/46890581_fsm" but retrying: No such file or directory 2012-08-05 01:07:43.659 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/47334522_fsm" but retrying: No such file or directory 2012-08-07 01:27:43.605 GMT 8966 4fd07ba5.2306 @: DEBUG: could not fsync file "base/16711/47579627_fsm" but retrying: No such file or directory