Re: Corrupted Dabatabase

On 06/27/2016 06:52 AM, Pau Marc Muñoz Torres wrote:
> hi
>
>  thank you for your quick answer,
>
>
>  I  am working with linux. here you have the output of uname --all
>
>
>
> Linux XXX at 2.6.18-274.3.1.el5 #1 SMP Tue Sep 6 20:13:52 EDT 2011
> x86_64 x86_64 x86_64 GNU/Linux
>
> And the filesystem is ext3
>
>  i was able to work with the database until last week when i was
> indexing the database. the problem came when i tried to cancel a \di command

How did you cancel the command?

Also elaborate on what you mean by 'indexing the database'?

>
>  as far as i know nothing  changed since the last time  i was working
> last week.
>
> p
>
>
> Pau Marc Muñoz Torres
> skype: pau_marc
> http://www.linkedin.com/in/paumarc
> http://www.researchgate.net/profile/Pau_Marc_Torres3/info/
>
>
> 2016-06-27 15:38 GMT+02:00 Alex Ignatov <a.ignatov@postgrespro.ru
> <mailto:a.ignatov@postgrespro.ru>>:
>
>
>     On 27.06.2016 16:28, Pau Marc Muñoz Torres wrote:
>>     Hello Everydody,
>>
>>      My database is corrupted, each time i try to list all the tables
>>     in the database  i have got the following message
>>
>>     hla2db=> \d
>>     ERROR:  could not open relation 1663/16385/1255: Read-only file system
>>
>>     I read that my best option is to use my backup. Before using my
>>     backup i would like to remove all databases in postgresql and
>>     create everything again from scratch. Unfortunatlly i can't see
>>     the list of databases, althought i am able to create databse
>>
>>
>>
>>      can you suggest what to do? is it a good idea to reinstall
>>     postgresql?
>>
>>
>>     Pau Marc Muñoz Torres
>>     skype: pau_marc
>>     http://www.linkedin.com/in/paumarc
>>     http://www.researchgate.net/profile/Pau_Marc_Torres3/info/
>>
>
>     May be you filesystem is mounted read-only after power loss or some
>     OS crash?
>
>     What OS do you have   - WIndows or some kind of Unix (Linux,  etc).
>     Also what  file system  Postgresql data dir is using?
>
>     Alex Ignatov
>     Postgres Professional: http://www.postgrespro.com
>     The Russian Postgres Company
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com