Re: read only error..hard reboot not work as well

From: "Mark Johnson" <mark(at)remingtondatabasesolutions(dot)com>
To: "Raman kumar" <raman36127(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: read only error..hard reboot not work as well
Date: 2011-07-13 19:09:18
Message-ID: W838101176138351310584158@webmail23
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


It seems postgres is suffering from a file system condition, so your solution lies there and not with postgres. There are many reasons why a file system can become read-only. For example, if you are using virtual machines and run in to a low I/O bandwidth condition, the vm software can put the file systems into a read-only state to prevent data corruption. Some clusterware and storage hardware vendors also do this on purpose to prevent corruption. Without knowing more about your system there are too many possbiel causes to list them here. My suggestion is to search the Internet for a possible cause/solution. If, for example, you are using vmware on Linux then you might want to Google for "vmware linux read only filesystem".
-Mark

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-07-13 19:49:46 Re: Importing SQL file into PostgreSQL database
Previous Message Elliot Voris 2011-07-13 18:43:55 Importing SQL file into PostgreSQL database