From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | "Jason K(dot) Ergle" <jason(dot)ergle(at)camotion(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Postgresql.conf getting corrupted |
Date: | 2009-09-01 03:03:14 |
Message-ID: | 20090901030314.GB6662@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-09-01 03:18:57 | Re: Postgresql.conf getting corrupted |
Previous Message | Jason K. Ergle | 2009-08-31 14:54:58 | Postgresql.conf getting corrupted |