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(dot)ignatov(at)postgrespro(dot)ru
> <mailto:a(dot)ignatov(at)postgrespro(dot)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(dot)klaver(at)aklaver(dot)com