Re: Issue during postgresql startup - Mailing list pgsql-general

From Yogesh Sharma
Subject Re: Issue during postgresql startup
Date
Msg-id 8F86F8F397DDD345B25EA2EF3E21648280134837@EXCH-MB02-U1.nectechnologies.in
Whole thread Raw
In response to Re: Issue during postgresql startup  (John R Pierce <pierce@hogranch.com>)
Responses Re: Issue during postgresql startup
List pgsql-general

 

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. .
-----------------------------------------------------------------------------------------------------------------------

pgsql-general by date:

Previous
From: Yogesh Sharma
Date:
Subject: Re: Issue during postgresql startup
Next
From: John R Pierce
Date:
Subject: Re: Issue during postgresql startup