|
Dear Sameer and all, >Looks like someone has been playing around with the database files or some disk issue. >Basically Postgres stores each table inside >$tablespace_dir/$database_dir/table_file >In this error it seems one of the files have been removed/lost Yes, I am suspecting a disk error or so. In that case I tried to add a dummy file “base/16385/1299988” using dd command. But while postgre start the file deleted automatically and it failed with same error. Is there any way to recover from this error or take dump of data and recreate DB from same dump ? BTW log files in pg_xlog also increased abruptly from the same time when this error started coming. Is it related to above error ?
Any help will be much appreciated ! Let me know if any other help is required. Thanks, Yogesh From: Sameer Kumar [mailto:sameer.kumar@xxxxxxxxxx]
On Thu, 28 Apr 2016 15:22 Yogesh Sharma, <Yogesh1.Sharma@xxxxxxxxxxxxxxxxxx> wrote:
Looks like someone has been playing around with the database files or some disk issue. Basically Postgres stores each table inside $tablespace_dir/$database_dir/table_file In this error it seems one of the files have been removed/lost
You might want to post the steps and backup file/date which you have used.
-- -- Best Regards Sameer Kumar | DB Solution Architect ASHNIK PTE. LTD. 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533 T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com DISCLAIMER: ----------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or NEC or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of NEC or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. . ----------------------------------------------------------------------------------------------------------------------- |
