From: Andres Freund <andres@2ndquadrant.com>
To: Nagaraj Shindagi <nagaraj.shindagi@gmail.com>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: during the maintenance facing error
Date: Sun, 10 Nov 2013 15:44:49 +0100
Message-ID: <20131110144449.GN28314@alap2.anarazel.de> (raw)
In-Reply-To: <CAB76fAxO9o1PxBQmkqjMFGo8XUAw3=2Qtaqc6uzmPqKQo0zb=w@mail.gmail.com>
References: <CAB76fAxO9o1PxBQmkqjMFGo8XUAw3=2Qtaqc6uzmPqKQo0zb=w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Hi,
On 2013-11-10 20:07:41 +0530, Nagaraj Shindagi wrote:
> This is nagaraj, while i am doing the maintenance of the database i am
> facing this problem, after this error it will stop and i am not able to
> take backup of the database.
What do you mean with "it will stop"? You should still be able to
communicate with the database, right?
> "ERROR: could not read block 984505 in file "base/16393/2850139.7": read
> only 4096 of 8192 bytes"
Hm. A couple of questions:
* which operating system
* which file system (cifs? veritas?)
* Could you do a "ls -l base/16393/2850139.*" in the server's datadir (SHOW
data_directory;) and send the output?
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: andres@2ndquadrant.com, nagaraj.shindagi@gmail.com, pgsql-hackers@postgresql.org
Subject: Re: during the maintenance facing error
In-Reply-To: <20131110144449.GN28314@alap2.anarazel.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox