Re: Corrupted Dabatabase

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

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>:

>
> 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
>
>
>