ition is mounted read only.
>
> -- Original Message --
> From: "Pau Marc Muñoz Torres"
> To: "pgsql general"
> Sent: 27/6/2016 4:28:35 PM
> Subject: [GENERAL] Corrupted Dabatabase
>
>
> Hello Everydody,
>
> My database is corrupted, each time i
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:/
You probably have a HDD problem.
Try a "cat /proc/mounts" and see if partition is mounted read only.
-- Original Message --
From: "Pau Marc Muñoz Torres"
To: "pgsql general"
Sent: 27/6/2016 4:28:35 PM
Subject: [GENERAL] Corrupted Dabatabase
Hello Everydo
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
On 2016-06-27 08:52, 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
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 w
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 optio
The issue sounds more like your server than just Postgres - search the
net for "read only file system" for your OS.
Tim Clarke
On 27/06/16 14: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 th
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 l
