> > I see, As there are many reasons exists for the data corruption i
couldn't
> > figure out it exactly.
> > Unfortunately there is no backup for this system and is not possible to
> > restore from the backup.
>
> Well, then, lost data is lost.
Oh.. My bad ...
>
> > I have been using the NFS stor
> > I see, As there are many reasons exists for the data corruption i
couldn't
> > figure out it exactly.
> > Unfortunately there is no backup for this system and is not possible to
> > restore from the backup.
>
> Well, then, lost data is lost.
Oh.. My bad ...
>
> > I have been using the NFS stor
On Thu, Mar 19, 2015 at 8:12 PM, Prajilal KP wrote:
> I see, As there are many reasons exists for the data corruption i couldn't
> figure out it exactly.
> Unfortunately there is no backup for this system and is not possible to
> restore from the backup.
Well, then, lost data is lost.
> I have b
Thank you Andrew for your reply.
I see, As there are many reasons exists for the data corruption i couldn't
figure out it exactly.
Unfortunately there is no backup for this system and is not possible to
restore from the backup.
I have been using the NFS storage since 2013 and didn't experience th
On Thu, Mar 19, 2015 at 07:02:28PM +0900, Prajilal KP wrote:
>
> When i see check the this file, the file itself exists but the size is "0"
> byte.
That suggests you have data corruption, and that you need to restore from
backup.
> The server is writing the whole log in to the mounted network st
Thank you Michael for the reply.
Here is the other log from pg_log directory
ERROR: could not open file "base/16384/7969143.26" (target block
13148261): No such file or directory
CONTEXT: SQL statement "select min(id), max(id)
from requests where id > last_max_id"
PL/pgSQL function "f_raw_log
On Thu, Mar 19, 2015 at 5:19 PM, Prajilal KP wrote:
> Recently i have noticed that my PostgreSQL server is returning the error
> messages like "Could not read block 6160722 in file
> "base/data/16384/11033028.47".
Don't you have more details to share? There should be some hint here
as well, and u
Hi all,
Thank you for reading this mail. I need your help to fix the issue with my
PostgreSQL server.
Recently i have noticed that my PostgreSQL server is returning the error
messages like “Could not read block 6160722 in file
“base/data/16384/11033028.47”.
When i have checked the "base/data/1638
