during the maintenance facing error
hi
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.
"ERROR: could not read block 984505 in file "base/16393/2850139.7": read
only 4096 of 8192 bytes"
Please help me to solve this issue
thanks in advance
--
Nagaraj V Shindagi
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