Re: Issue during postgresql startup

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

In response to

Responses

Browse pgsql-general by date

  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