On Thu, 28 Apr 2016 15:22 Yogesh Sharma, <yogesh1.sha...@nectechnologies.in> wrote:
> Dear All, > > Thanks for your support. > > Could you please tell me, how to recover my system. > > I am facing below errors. > --------------------------- > could not open relation 1663/16385/1299988: No such file or directory > --------------------------- > > This message is continuous occurred in system . > 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 > I have tried below procedure for the same but after recover this system, > all DB tables are destroyed. > http://www.hivelogik.com/blog/?p=513 > > You might want to post the steps and backup file/date which you have used. Please let me know if any solution. > > Regards, > Yogesh > > > > 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. . > > ----------------------------------------------------------------------------------------------------------------------- > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- 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
