Re: Issue during postgresql startup

Поиск
Список
Период
Сортировка
От Sameer Kumar
Тема Re: Issue during postgresql startup
Дата
Msg-id CADp-Sm5SMHH77fGL0adyPV5m8tp9NL-CcZzFaWAQadNBFCsiBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Issue during postgresql startup  (Yogesh Sharma <Yogesh1.Sharma@nectechnologies.in>)
Ответы Re: Issue during postgresql startup  (Yogesh Sharma <Yogesh1.Sharma@nectechnologies.in>)
Список pgsql-general


On Thu, 28 Apr 2016 15:22 Yogesh Sharma, <Yogesh1.Sharma@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

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Issue during postgresql startup
Следующее
От: Yogesh Sharma
Дата:
Сообщение: Re: Issue during postgresql startup