Postgresql.conf getting corrupted

This is a multi-part message in MIME format.

------=_NextPart_000_016B_01CA2A29.7C3C1AE0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I am having a problem with postgreql.conf becoming corrupted. We are using
version 8.2.9 in embedded systems running Fedora Core 7. Basically, the
postgres server holds the data that our embedded systems need to run. They
are all using industrial solid state disk drives on the ext3 file system.
The systems are cold booted occasionally by the operators if something
becomes unresponsive. I am not having a problem with the actual database,
but it seems as though the postgresql.conf file becomes corrupted on
occasion. What happens is a random character in the file, such as an =
will be replaced with another character, such as a 5. Then the server
refuses to start because of a syntax error in the file.



This is confusing to me, as I would expect the configuration file to only be
read and startup, and never to be written too. Thus far we have not had any
software or data systems become corrupted, but the configuration file has
become corrupted on 3 separate systems thus far. Does anyone have any idea
how/why this is happening? Or what I may do to prevent it? I understand
that cold booting is bad for the systems, but that's a reality of types of
systems we are installing, so I have to deal with it.



Thanks,

Jason


------=_NextPart_000_016B_01CA2A29.7C3C1AE0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/mee tings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/partto part" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsi g-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsi g" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor talServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:export-only;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal>I am having a problem with postgreql.conf becoming
corrupted.  We are using version 8.2.9 in embedded systems running =
Fedora
Core 7.  Basically, the postgres server holds the data that our =
embedded
systems need to run.  They are all using industrial solid state =
disk
drives on the ext3 file system.  The systems are cold booted =
occasionally by
the operators if something becomes unresponsive.  I am not having a
problem with the actual database, but it seems as though the =
postgresql.conf
file becomes corrupted on occasion.   What happens is a random
character in the file, such as an =3D will be replaced with another =
character,
such as a 5.  Then the server refuses to start because of a syntax =
error
in the file. <o:p></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal>This is confusing to me, as I would expect the =
configuration
file to only be read and startup, and never to be written too.  =
Thus far
we have not had any software or data systems become corrupted, but the
configuration file has become corrupted on 3 separate systems thus =
far. 
Does anyone have any idea how/why this is happening?  Or what I may =
do to
prevent it?  I understand that cold booting is bad for the systems, =
but that’s
a reality of types of systems we are installing, so I have to deal with =
it.<o:p></o:p></p>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal>Thanks,<o:p></o:p></p>

<p class=3DMsoNormal>Jason<o:p></o:p></p>

</div>

</body>

</html>

------=_NextPart_000_016B_01CA2A29.7C3C1AE0--
jason.ergle [ Mo, 31 August 2009 16:54 ] [ ID #2014236 ]

Re: Postgresql.conf getting corrupted

Jason K. Ergle wrote:
> I am having a problem with postgreql.conf becoming corrupted. We are using
> version 8.2.9 in embedded systems running Fedora Core 7. Basically, the
> postgres server holds the data that our embedded systems need to run. They
> are all using industrial solid state disk drives on the ext3 file system.
> The systems are cold booted occasionally by the operators if something
> becomes unresponsive. I am not having a problem with the actual database,
> but it seems as though the postgresql.conf file becomes corrupted on
> occasion. What happens is a random character in the file, such as an =
> will be replaced with another character, such as a 5. Then the server
> refuses to start because of a syntax error in the file.

That's pretty weird. Are you using something like pgadmin to change the
server's configuration? The config file is not opened for writing
normally.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Alvaro Herrera [ Di, 01 September 2009 05:03 ] [ ID #2014237 ]

Re: Postgresql.conf getting corrupted

"Jason K. Ergle" <jason.ergle [at] camotion.com> writes:
> I am having a problem with postgreql.conf becoming corrupted. We are using
> version 8.2.9 in embedded systems running Fedora Core 7. Basically, the
> postgres server holds the data that our embedded systems need to run. They
> are all using industrial solid state disk drives on the ext3 file system.
> The systems are cold booted occasionally by the operators if something
> becomes unresponsive. I am not having a problem with the actual database,
> but it seems as though the postgresql.conf file becomes corrupted on
> occasion. What happens is a random character in the file, such as an =
> will be replaced with another character, such as a 5. Then the server
> refuses to start because of a syntax error in the file.

I'd bet lunch you have bad RAM that's dropping a bit every so often.
It's worthy of note that ASCII '=' is 0x3D while '5' is 0x35, just
one bit different.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Tom Lane [ Di, 01 September 2009 05:18 ] [ ID #2014238 ]
Datenbanken » gmane.comp.db.postgresql.admin » Postgresql.conf getting corrupted

Vorheriges Thema: archive_command
Nächstes Thema: RAID10 and chunk size