Dear John,
>did you get that 'no such file or directory' error before or after you reset the transaction logs ?
The error message is coming before.
>messing with the write-ahead logs is very dangerous. that blog is talking about postgres 8.4, based on his paths. is that what you're running?
We are running postgres 8.3.
Regards,
Yogesh
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of John R Pierce
Sent: Thursday, April 28, 2016 1:44 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Issue during postgresql startup
On 4/28/2016 12:21 AM, Yogesh Sharma wrote:
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 .
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
did you get that 'no such file or directory' error before or after you reset the transaction logs ?
messing with the write-ahead logs is very dangerous. that blog is talking about postgres 8.4, based on his paths. is that what you're running?
I'd be hesitant to rely on random blog advise, without thoroughly understanding what you're doing.
--
john r pierce, recycling bits in santa cruz
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. .
-----------------------------------------------------------------------------------------------------------------------