Re: read only error..hard reboot not work as well - Mailing list pgsql-admin

From Mark Johnson
Subject Re: read only error..hard reboot not work as well
Date
Msg-id W838101176138351310584158@webmail23
Whole thread Raw
In response to read only error..hard reboot not work as well  (Raman kumar <raman36127@gmail.com>)
List 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

pgsql-admin by date:

Previous
From: Elliot Voris
Date:
Subject: Importing SQL file into PostgreSQL database
Next
From: "Kevin Grittner"
Date:
Subject: Re: Importing SQL file into PostgreSQL database