Re: Corrupted Dabatabase

Alex Ignatov <a.ignatov@xxxxxxxxxxxxxx> · Mon, 27 Jun 2016 16:38:58 +0300



    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