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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com