Re: Corrupted Dabatabase

On 06/27/2016 07:23 AM, Pau Marc Muñoz Torres wrote:

Please reply to list also.
Ccing list

> i did a cancel + c
>
>   i suppose this is the problem

I routinely do that with no problems.

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


>
> 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 16:09 GMT+02:00 Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>:
>
>     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>
>         <mailto: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 <mailto:adrian.klaver@aklaver.com>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com