From: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com> |
---|---|
To: | Yogesh Sharma <Yogesh1(dot)Sharma(at)nectechnologies(dot)in>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Issue during postgresql startup |
Date: | 2016-04-28 08:14:56 |
Message-ID: | CADp-Sm5SMHH77fGL0adyPV5m8tp9NL-CcZzFaWAQadNBFCsiBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 28 Apr 2016 15:22 Yogesh Sharma, <Yogesh1(dot)Sharma(at)nectechnologies(dot)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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Yogesh Sharma | 2016-04-28 08:28:02 | Re: Issue during postgresql startup |
Previous Message | John R Pierce | 2016-04-28 08:14:12 | Re: Issue during postgresql startup |